Answer
Blocking occurs when one transaction holds a lock and others wait behind it.
Deadlock occurs when two transactions wait on each other, creating a cycle.
SQL Server detects deadlocks and kills one transaction (the victim) to resolve the cycle.
Blocking occurs when one transaction holds a lock and others wait behind it.
Deadlock occurs when two transactions wait on each other, creating a cycle.
SQL Server detects deadlocks and kills one transaction (the victim) to resolve the cycle.
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ