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

Using MS SQL COUNT

MS SQL Getting a Random Row in a Table

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

What is an Online Rebuilding of Indexes in SQL Server ?

Changing Column Name of MS SQL Table with Query