Why we need to use secondry database file? though, we can
do same work using primary database file also.
Answer Posted / sagi.rahul
Secondary files can be used to spread data across multiple
disks by putting each file on a different disk drive which
will improve i/o.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How will you know when statistics on a table are obsolete?
What is de-normalization in sql database administration? Give examples?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is awe?
Should you normalize audio?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What do you mean by cardinality?
How do I setup a local sql server database?
What are system databases into sql server (2005/2008) : sql server database administration
Explain the etl (extraction, transformation, and loading)?
What are indexes in sql?
How do I uninstall sql server 2014?
What stored by the master? : sql server database administration
What is attribute hierarchy? : sql server analysis services, ssas
What is merge join?