Chapter 12. Transactions and Locks
Ahhhh... the fundamentals. In this case, a fundamental that even lots of fairly advanced users don't quite "get it" on. I've said it in every version of this book I've done, and even in my Beginning SQL Server 2005 Programming title: nothing in this chapter is wildly difficult, yet transactions and locks tend to be two of the most misunderstood areas in the database world.
This is one of those chapters that, when you go back to work, make you sound like you've had your Wheaties today. Nothing in what we're going to cover in this chapter is wildly difficult, yet transactions and locks tend to be two of the most misunderstood areas in the database world. As such, this "beginning" (or at least I think it's a basic) concept is going to make you start to look like a real pro.
In this chapter, we're going to:
Examine transactions
Examine how the SQL Server log and "checkpoints" work
Unlock your understanding of locks
We'll learn why these topics are so closely tied to each other, and how to minimize problems with each.
Get Professional SQL Server™ 2005 Programming 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.
