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 |
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to perform backup for certificates in sql server? : sql server security
How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?
How do I open port 1433?
What is the process of normalising?
How to write character string constants or literals in ms sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What do you understand by hotfixes and patches in sql server?
Describe in brief system database.
What is optimistic concurrency?
Explain the stored procedure?
Explain having clause and where clause?