What is the query optimization statistics?

1 Answers  

---

what is Covering Index ?

3 Answers   Thomson Reuters,

---

What is transaction server explicit transaction?

0 Answers  

---

What stored by the tempdb ? : sql server database administration

0 Answers  

---

How to count the number of duplicate items in a table?

3 Answers  

---

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

How will you decide the active and passive nodes?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

Explain system rowset functions?

0 Answers  

---

Explain sub-query?

0 Answers  

---

What are the instances when triggers are appropriate?

0 Answers  

---

Define union, union all, minus, intersect?

0 Answers  

---