O'Reilly logo

MCITP SQL Server 2005 Database Administration All-in-One exam Guide by Darril Gibson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required