What should be the fill factor for indexes created on tables? : sql server database administration

1138

---

What is lock escalation? : sql server database administration

1155

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1037

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

973

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1015

---

What are the difference between primary key and unique key? : sql server database administration

939

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

922

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1040

---

What type of locking occurs during the snapshot generation? : sql server replication

1332

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

1512

---

What are the different types of sql server replication? : sql server replication

1263

---

How will you monitor replication latency in transactional replication? : sql server replication

1141

---

What is sql server replication? : sql server replication

983

---

What is the difference between push and pull subscription? : sql server replication

1214

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

976

---