SQL
Deadlocks and Lock Contention
Why two transactions can wait for each other forever, how the database resolves it, and the design habits that prevent deadlocks and reduce contention...
#Locking
Locks, deadlocks and contention.
2 notes tagged
SQL
Locks: Shared, Exclusive, Row and Table Level
How the database stops two transactions corrupting each other: lock modes, granularity, locking reads, and why an unindexed WHERE clause can lock a wh...