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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a query with an inner join in ms sql server?

647


What are different types of replication in sql server?

659


Why use “in” clause in sql server?

637


Does server sql treat char as a variable-length or fixed-length column?

683


What is candidate key with example?

607






After removing a table from database, what other related objects have to be dropped explicitly?

659


What are approximate numeric data types in ms sql server?

664


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1523


What is normalization of database? What are its benefits?

589


What is difference in performance between insert top (n) into table and using top with insert?

628


Who is the owner of a schema in ms sql server?

628


How to use the inserted and deleted pseudo tables?

612


Why do you want to join software field as you have done your BE in Electronics?

1785


What is the difference between primary key and unique constraints?

590


What are data driven subscriptions?

85