Why we need to use secondry database file? though, we can
do same work using primary database file also.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is resource governor?
What is the sql profiler?
How to create a simple table to test triggers in ms sql server?
Mention the different authentication modes in sql server.
What is the difference between Stored Procedures and triggers?
What is index in an assignment?
Can you explain what is the use of custom fields in report?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What are cursors in ms sql server?
what is isolation level at dead lock?
What is the query and subquery?
Can a cursor be updated? If yes, how you can protect which columns are updated?