⟩ Do you know what are different types of replication in SQL Server?
There are three types of replication in SQL SERVER
1. Snapshot Replication.
2. Transactional Replication
3. Merge Replication
There are three types of replication in SQL SERVER
1. Snapshot Replication.
2. Transactional Replication
3. Merge Replication
Explain optimistic and pessimistic concurrency?
Explain the various types of concurrency problem?
Explain different types of lock modes in SQL Server 2000?
Do you know what guidelines should be followed to help minimize deadlocks?
What is a dead lock?
What is a live lock?
What is SQL Server locking?
Explain what is lock escalation and what is its purpose?
Explain Atomicity?
What is Transaction Server Isolation?