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 Order By

What is CTE in SQL Server ?

What is Service Broker in SQL Server ?

Deleting Columns From a Table with a Query in MS SQL

Making a Backup of MS SQL Database With Query