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.

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

What does it mean to be in union?

0 Answers  

---

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

What is the difference between mysql and sql server?

0 Answers  

---

Explain the purpose of indexes?

0 Answers  

---

Do you know how to send email from database?

0 Answers  

---

What are distributed partitioned views?

0 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

Give an example of why you would want to denormalize a database

0 Answers  

---