One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...
Deadlocks are different from classic blocking behavior. Blocking means one transaction is waiting for a resource (e.g. a row in the process of being updated) that is locked by another. This causes a ...