How does a covering index work?

0 Answers  

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

Should I use mbr or gpt?

0 Answers  

---

Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

what is self join and why is it required? : Sql dba

1 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

How does rowid help in running a query faster?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---