Why we need to use secondry database file? though, we can
do same work using primary database file also.
- 2 Answers
- 6193 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Explain why variables called the most powerful component of ssis?
What do you understand by triggers and mention the different types of it?
What is pessimistic concurrency?
Mention the different types of replication in sql server.
What are the steps you can take to avoid “deadlocks”?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How do you open a cluster administrator?
What is a raid and what are different types of raid configurations?
In which sql server version report builder introduced?
Explain a differential backup?
What is @@error in sql?
what are the different stages of Report Processing?
What are “unrepeatable reads”?
What is difference between group by and having?
What is 2nf normalization?
