What is the maximun sixes of .mdf in sql server 2005

Question Posted / benjamin

What is the maximun sixes of .mdf in sql server 2005..

Answer / benjamin

4GB in 2005 and 2000 2GB

Is This Answer Correct ?

3 Yes

2 No

More SQL Server Interview Questions

What is stored in the mssqlsystemresource database? : sql server database administration

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

Can some one please help with a query which will take only max value of a column in a join.

How many types of system privileges are there, Can we add or delete privileges?

How to find index size for each index on table?

Which index created when Create Index on table(col), Why

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

What are dml (data manipulation language) statements in ms sql server?

What is difference between drop truncate and delete?

How we can refresh the view?

What is the difference between inner join and equi join?

What are the 2 types of classifications of constraints in the sql server?

For more SQL Server Interview Questions Click Here