Chapter 31. Transaction Management and the Transaction Log

IN THIS CHAPTER

• What’s New in Transaction Management

• What Is a Transaction?

• How SQL Server Manages Transactions

• Defining Transactions

• Transactions and Batches

• Transactions and Stored Procedures

• Transactions and Triggers

• Transactions and Locking

• Coding Effective Transactions

• Transaction Logging and the Recovery Process

• Long-Running Transactions

• Bound Connections

• Distributed Transactions

Transaction management is an important area in 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 looks at the methods for defining and managing transactions ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.

Start your free trial