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 can do you the system monitoring?

1 Answers  

---

What is a with(nolock)?

0 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

---

Will count(column) include columns with null values in its count?

0 Answers  

---

What is history table in sql server?

0 Answers  

---

What is the benefit of normalization?

0 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

What is attribute? : sql server analysis services, ssas

0 Answers  

---

How to find the version of sql server? : sql server database administration

0 Answers  

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---