What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

How to set database to be single_user in ms sql server?

0 Answers  

---

How to count duplicated values in a column in ms sql server?

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

---

---

How to set database to be read_only in ms sql server?

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

Explain the disadvantages/limitation of the cursor?

0 Answers  

---

What are group functions in query statements in ms sql server?

0 Answers  

---

Can you have a nested transaction?

4 Answers   HCL,

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---