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.

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.

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

your distribution database is full what will u do

0 Answers  

---

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

---

what is the primary use of the model database? : Sql server administration

0 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

Explain full-text indexing?

0 Answers  

---

What are the mathematical functions supported by sql server 2005?

0 Answers  

---

Explain raiserror in sql server?

0 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

Do you know the policy based administration feature of sql server 2008?

0 Answers  

---

How can we delete Duplicate row in table?

0 Answers   Wipro,

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---