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

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with O’Reilly online learning.

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