Transaction Isolation Levels
Transaction Isolation Levels are used to control data access concurrency. Concurrency controls can be Pessimistic or Optimistic.
Serializable
Concurrency: Phantom Reads
A closer look at the Serializable Transaction Isolation Level and how it could prevent Phantom Reads concurrency issues in SQL Server.