January 2009
Intermediate to advanced
792 pages
23h 8m
English
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 ...