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.

How to use transact-sql statements to access the database engine?

0 Answers  

---

What is a with(nolock)?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is a system database and what is a user database?

0 Answers  

---

Where can you find the error log information? : sql server database administration

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

What is abstracting periodical?

0 Answers  

---

How you can minimize the deadlock situation?

0 Answers  

---

What is a periodical index?

0 Answers  

---