O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer 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 14Locks and Cursors

In this chapter, you will learn about:

• Locks

• Deadlocks

• Transaction isolation levels

• Hints

• Cursors

Complex problems have simple easy-to-understand wrong answers.

—Grossman's Law

A good database is always seeking a balance between:

1. Allowing as many users as possible to use the database at the same time (high concurrency) and,

2. Preventing problems from multiple users accessing the same data when one or more users are trying to modify the data (through the judicious use of locks).

For the many SQL Server databases, locks occur automatically within the database, and database developers often don't need to know how to troubleshoot locks. However, blocking locks cause problems, and when they do occur you ...

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