How is Deadlock Different From a Blocking Situation in SQL Server ?

A deadlock occurs when two or more tasks permanently block each other by having a lock on a resource that the other tasks are trying to lock. In a deadlock situation, both transactions in the deadlock will wait forever unless the deadlock is broken while in a standard blocking scenario, the blocked task will simply wait until the blocking task releases the conflicting lock scenario.



You May Interest

What is the Difference Between VARCHAR and NVARCHAR in SQL Server ...

Creating a View in MS SQL

What is a Covered Index in SQL Server ?

Using MS SQL WHERE

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...