Pro SQL Server 2008 Relational Database Design and Implementation

CHAPTER 10Coding for Concurrency

"Time is the scarcest resource, and unless it is managed, nothing else can be managed."

—Peter F. Drucker

Concurrency is all about having the computer utilize all of its resources simultaneously, or basically having more than one thing done at the same time when serving multiple users (technically in SQL Server, you open multiple requests, on one or more connections). Even if you haven't done much with multiple users, if you know anything about computing you probably are familiar with the term multitasking. The key here is that when multiple processes or users are accessing the same resources, each user expects to see a consistent view of the data and certainly expects that other users will not be stomping ...