Transaction Isolation Levels
Transaction Isolation Levels are used to control data access concurrency. Concurrency controls can be Pessimistic or Optimistic.
nonrepeatable read
Concurrency: Inconsistent Analysis
A closer look at the Repeatable Read Transaction Isolation Level and how it could help with Inconsistent Analysis concurrency issues in SQL Server.