In this chapter, you will learn about:
• Transaction isolation levels
Complex problems have simple easy-to-understand wrong answers.
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 ...