SQL Server Concurrency–Dirty Reads
Database concurrency ensures that when multiple operations are occurring at once, the final result is still in agreement. Dirty reads can happen when multiple sessions are occurring at once in your SQL Server database instance.
Read More