Transaction processing

No matter what concurrency model you’re working with, that you have an understanding of transactions is crucial. A transaction is the basic unit of work in SQL Server. Typically, it consists of several SQL commands that read and update the database, but the update isn’t considered final until a COMMIT command is issued (at least for an explicit transaction). In general, when discussing a modification operation or a read operation, this chapter is talking about the transaction that performs the data modification or the read, which isn’t necessarily a single SQL statement. The expression writers will block readers means that as long as the transaction that performed the write operation is active, no other process can read ...

Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.

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