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.



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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.