Does index speed up select statements?

0 Answers  

---

Can you explain different types of locks in sql server?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

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 are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

what is a stored procedure and trigger?

3 Answers  

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---