Summary

In this chapter, you’ve learned about transactions, how they are managed by default by SQL Server, and how you can explicitly manage them. We covered topics including the ACID properties of a transaction, the transaction modes that can be used to specify the beginning and the end of a transaction, how resource locks are used to protect data consistency, and the different ways to control transactions and locking behavior. We’ve also taken a look at blocking, deadlocks, and the isolation levels, including the new read committed snapshot, snapshot isolation database option, and the new snapshot isolation level. These concepts of transactions, locking, blocking, and isolation are critical to understand and must be used appropriately in order ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.