Defining locks, blocks and deadlocks
Lock
,
block
and
deadlock
are three related terms in SQL Server. They have a specific meaning and are often confused with each other. I hope to clear them up here.