Explain about merge replications?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

Difference between uniqe index and uniqe constraint?

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  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

---

Explain what is it unwise to create wide clustered index keys?

0 Answers  

---

Explain the phases a transaction has to undergo?

0 Answers  

---

What are policy management terms?

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

---

What is difference between foreign key and unique key?

0 Answers  

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

---