O'Reilly logo

Mastering SQL Server® 2008 by Gentry Bieker, Michael Lee

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

Chapter 15

Transactions and Locking

Business systems are complex. Frequently, data modifications that take place in one area of the database must occur concurrently with modifications made somewhere else. These processes must occur transactionally to ensure that you maintain data integrity. Transactional operations follow the ACID formula, which states that all transactions should be atomic, consistent, isolated, and durable. The "I" in ACID stands for isolated, which means that the data impacts of one transaction will influence no other transaction until the isolated transaction completes, either by committing or rolling back. SQL Server enforces isolation through its locking architecture. Locks on resources prevent operations in this shared ...

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