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

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

Post New Answer

More SQL Server Interview Questions

Do you know how to implement service broker?

0 Answers  


How to get @@error and @@rowcount at the same time?

0 Answers  


IN Vs OR operator which is best to use sql server.

4 Answers  


Can group functions be used in the order by clause in ms sql server?

0 Answers  


What is the difference between index seek vs. Index scan?

0 Answers  






What are the transaction properties?

0 Answers  


What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,


what is differece between union and union all

6 Answers  


What is cursors? And what are the different types of cursor?

0 Answers  


What is bulkcopy in sql?

0 Answers  


You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  


What is a schema in ms sql server 2005?

0 Answers  


Categories