Chapter 31. Transaction Management and the Transaction Log

by Ray Rankins


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

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features