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

Changing MS SQL Table Name with Query

List of Table Columns Used in Any View in MS SQL

Disabling a Specified Trigger in MS SQL Server

What is RAISEERROR in SQL Server ?

MS SQL Finding Which Tables a Column Name is In