Chapter 5. Transactions and Concurrency
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 ...