How many .ndf files can we create in Sql server 2005?

Question Posted / vamsimadineni

Answers were Sorted based on User's Feedback

How many .ndf files can we create in Sql server 2005?..

Answer / anil kumar

32766

Is This Answer Correct ?

4 Yes

1 No

How many .ndf files can we create in Sql server 2005?..

Answer / anilreddy

I am not sure but I do not think there is limit for .ndf files.As needed we can go on adding.

Is This Answer Correct ?

1 Yes

1 No

More SQL Server Interview Questions

What is it unwise to create wide clustered index keys?

What is the default value of an integer data type in sql server 2005?

What is normalization process?

How is table type constraint applied to a table?

How to change the ownership of a schema in ms sql server?

How to list all stored procedures in the current database using ms sql server?

How to use order by with union operators in ms sql server?

If the job running very slow what is the action you do

What is snapshot replication?

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

Why Do you want to work in this company?

How to display a past time in days, hours and minutes?

For more SQL Server Interview Questions Click Here