Chapter 6. Managing Transactions and Locks

IN THIS CHAPTER, YOU WILL LEARN TO DO THE FOLLOWING:

  • MANAGE SQL SERVER LOCKS (Pages 189 – 199)

    • Identify Lock Types and Behaviors (Page 189)

    • Identify Lock Compatibility (Page 193)

    • Manage Locking Behavior (Page 194)

  • MANAGE TRANSACTIONS (Pages 199 – 208)

    • Creating Transactions (Page 200)

    • Handling Transaction Errors (Page 203)

    • Using Savepoints in Transactions (Page 205)

  • IMPLEMENT DISTRIBUTED TRANSACTIONS (Pages 208 – 217)

    • Understanding Distributed Queries (Page 209)

    • Defining Distributed Transactions (Page 215)

  • MANAGE SPECIAL TRANSACTION SITUATIONS (Pages 217 – 220)

    • Concurrency and Performance (Page 217)

    • Managing Deadlocks (Page 218)

    • Setting Lock Time-Outs (Page 220)

In a shared database environment, it is critical that ...

Get SQL Server® 2008 Administration: Instant Reference 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