Expert SQL server transactions and locking: concurrency internals for SQL server practitioners

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers.

This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.

SQL Server's Concurrency Model is one of the least understood parts of the SQL Server Database Engine.

Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine.

While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book.