Chapter 5. Transactions and Concurrency
Itzik Ben-Gan
This chapter covers various aspects of concurrency that you need to consider when developing code for SQL Server. It covers transactions, locking, blocking, isolation levels, and deadlocks. It also covers the new LOCK_ESCALATION option of ALTER TABLE, which gives you better control over how lock escalation behaves.
Note
In this chapter I cover features that are directly related to transactions and concurrency. Some other new features in SQL Server 2008 may have an impact on concurrency, especially if they improve the performance of certain activities and as a result finish sooner and release locks ...
Get Inside Microsoft® SQL Server® 2008: T-SQL Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
