The concurrency model is, perhaps, the least understood part of SQL Server internals. It can often be confusing; you can encounter hard-to-explain blocking issues in almost every SQL Server installation. Internally, however, the SQL Server concurrency model is based on several well-defined principles, which we are going to discuss in this part of the book.
This chapter starts with the key concept of SQL Server concurrency— locks. It will provide an overview of the major lock types in SQL Server, explain their compatibility, and, finally, demonstrate how different ...
