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.

Can we hide the definition of a stored procedure from a use?

867

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

732

---

What happens if you delete a table that is used by a view?

750

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

705

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

738

---

---

What are the new security features added in sql server 2012? : sql server security

702

---

What are Row versions of DataRow?

784

---

What different steps will a sql server developer take to secure sql server?

722

---

Difference between uniqe index and uniqe constraint?

716

---

How to apply cascading referential integrity in place of triggers?

743

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

752

---

What happens to a statement batch if there is a compilation error?

698

---

What are the differences between user defined functions and stored procedures?

737

---

Can two tables have the same primary key?

866

---

What is a DBMS, query, SQL?

772

---