Chapter 9. Transactions and Concurrency

This chapter covers transactions and their properties and describes how Microsoft SQL Server handles users who are concurrently trying to access the same data. I explain how SQL Server uses locks to isolate inconsistent data, how you can troubleshoot blocking situations, and how you can control the level of consistency when you are querying data with isolation levels. This chapter also covers deadlocks and ways to mitigate their occurrence.

Transactions

A transaction is a unit of work that might include multiple activities that query and modify data and that can also change data definition.

You can define transaction boundaries either explicitly or implicitly. You define the beginning of a transaction explicitly ...

Get Microsoft® SQL Server® 2012 T-SQL Fundamentals now with O’Reilly online learning.

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