Transaction Isolation Levels
Transaction Isolation Levels are used to control data access concurrency. Concurrency controls can be Pessimistic or Optimistic.
lost updates
Concurrency: Lost Updates
A closer look at the Read Committed Transaction Isolation Level and how it could allow Lost Update concurrency issues in SQL Server.