CHAPTER 15 Managing Concurrency

In this chapter, you will learn about:

• Locks

• Deadlocks

• Transaction isolation levels

I happen to feel that the degree of a person's intelligence is directly reflected by the number of conflicting attitudes she can bring to bear on the same topic.

—Lisa Alther

In a perfect world, there would be no conflict. Whatever you want, whenever you want it, it's yours. Whatever your neighbors want, whenever they want it, it's there for them. And all of our desires would mingle happily.

In a perfect database, there would be no contention. Whatever one transaction wanted to read or modify, whenever it wanted to read or modify it, it would be there. Other transactions likewise could read or modify data concurrently (at ...

Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 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.