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 are the System Data Collection Sets Predefined Inside SQL Se ...

MS SQL Restoring a Database With a Query

What is Resource Governor in SQL Server ?

Adding Columns to a Table with a Query in MS SQL

Disadvantages of Using Stored Procedures in MS SQL