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