O'Reilly logo

Microsoft SQL Server 2012 Internals by Bob Beauchemin Kalen Delaney Conor Cunningham, Jonathan Kehayias, Benjamin Nevarez, and Paul S. Randal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required