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

How is Sqlcmd Different from Osql ?

Disabling All Constants in a Table in MS SQL

What is CHECKPOINT Process in the SQL Server ?

Disadvantages of Using Stored Procedures in MS SQL

List of Table Columns Used in Any View in MS SQL