Concurrency Problems
In a multiuser environment, as several users try to access the same data at the same time, trying to perform different actions, you can encounter various concurrency problems.
In the following sections you learn every potential problem and, later in this chapter, you will see how to use the right isolation level to solve the concurrency problem and how SQL Server uses locks to support these isolation levels.
Every concurrency problem is illustrated with a figure. Every figure shows two connections, called Connection A and Connection B. These two connections can be made from the same computer or from different computers, and by the same user or by different users. SQL Server has to solve concurrency problems between connections, ...
Get Microsoft® SQL Server™ 2000 Programming by Example 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.
