Locking, Blocking, and Deadlocks: What They Are and How They Work
There are a few terms that often are confused in SQL Server. These are locking, blocking, and deadlocks. These are all very different from each other.
Locking is a normal and desirable process. Blocking is also normal, but is less desirable. Deadlocking is not a normal process and is never desirable.
Read more