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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.