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.



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net