Which is the main third-party tool used in sql server?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

Can you have a nested transaction?

4 Answers   HCL,

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

---

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

How would you choose between a clustered and a non-clustered index?

0 Answers  

---

What is bcp? When does it use?

0 Answers  

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

what is the difference between procedure and function.

4 Answers   Thomson,

---

What is constraints and its types?

0 Answers  

---