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
What is data modeling and Reterminal integrity?
Explain cdc and sql injection?
Explain the different index configurations a table can have?
When a primary key constraint is included in a table, what other constraints does this imply?
Explain linked server in sql?
What is catalog views?
What is the primary use of the model database?
What is entity data services?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Define master database?
What is the correct order of the logical query processing phases?
Can you explain various data region available in ssrs with their use?
Name some of the open source software that you can use in alternative to SSR?
What are number line correlation administrators will use while working with a subquery?
What is sql server locking?