Chapter 31. Transaction Management and the Transaction Log
by Ray Rankins
IN THIS CHAPTER
What Is a Transaction?
How SQL Server Manages Transactions
Defining Transactions
Transaction Logging and the Recovery Process
Transactions and Batches
Transactions and Stored Procedures
Transactions and Triggers
Transactions and Locking
Coding Effective Transactions
Long-Running Transactions
Bound Connections
Distributed Transactions
Transaction management is an important area within database programming. The transactions you construct and issue can have a huge impact on the performance of SQL Server and the consistency of your databases. This chapter takes a look at the methods for defining and managing transactions within SQL Server 2000.
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
