The Read Uncommitted Isolation Level

(Paul White) Read uncommitted is the weakest of the four transaction isolation levels defined in the SQL Standard (and of the six implemented in SQL Server). It allows all three so-called “concurrency phenomena”, dirty reads, non-repeatable reads, and phantoms:

Read More - Register for Free Membership