Blocking:
It happens when one connection holds a lock and a second condition requires a connection lock type. This forces the second connection requires a conflicting a lock type.
Replication:
This is the process of Copying/moving data between databases on the same or different servers.
SQL Server supports following types of replication. They are
It happens when one connection holds a lock and a second condition requires a connection lock type. This forces the second connection requires a conflicting a lock type.
Replication:
This is the process of Copying/moving data between databases on the same or different servers.
SQL Server supports following types of replication. They are
- Snapshot
- Transaction Replication
- Merge Replication
No comments :
Post a Comment