Explain what is lock escalation and what is its purpose?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

What is sql server database?

0 Answers  

---

What is Right Outer Join?

2 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

How to create nested stored procedure?

0 Answers  

---

How to insert data with null values?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

What are the different types of replication you can set up in sql server?

0 Answers  

---