Delaney Kalen. SQL Server Concurrency: Locking, Blocking, and Row Versioning

Red Gate Books, 2013. — 202 p. This book explores how SQL Server uses locks to avoid concurrency problems, and advice on the to control locking with hints and bound connections. It also walks you through how row versioning works, and how to troubleshoot excessive blocking and deadlocking.