Interested to Buy Any Domain ? << Click Here >> for more details...
Why we need to use secondry database file? though, we can
do same work using primary database file also.
- 2 Answers
- 6842 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sivasql
The reason for secondary database files:
1. Performance
Say if we keep Read-Only and Read-Write data on the same
Primary files, fragmentation on the file will be huge. To
avoid this we can place them separate files.
2. Maintenance
If the Read-Only objects are kept on separate file, the Re-
Index sort of maintenance activities need not be performed
on this file.
3. Backup
The Read-only secondary file need not be backed on every
file level backup, it saves time
4. Microsoft Standard
Microsoft advise to keep the Primary filegroup with the
primary file to keep system related objects.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is optimistic concurrency?
Can we write trigger for view?
Explain the steps to use transact-sql cursor?
Write a SQL query to delete a table?
What is a select query statement in ms sql server?
how would you troubleshoot blocking? : Sql server database administration
What do you understand by the data quality services in sql server?
Explain filtered indexes?
What are different types of raid configurations? : SQL Server Architecture
How to delete multiple rows with one delete statement in ms sql server?
What is 2nf normalization form?
How to create a user name in a database?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is schemabinding a view?
What are the new features of sql server 2012 reporting service?
