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,

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

---

How many levels of sp nesting are possible?

0 Answers  

---

What is the function of sql server agent windows service?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

What is filter index?

0 Answers  

---

What do you mean by sql server agent?

0 Answers  

---

What are the advantages of log shipping?

0 Answers  

---

What is user-defined multi-statement table-valued function?

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

---