Read Committed Snapshot Isolation
Read Committed Snapshot Isolation . You would get a result similar to the below. Sql server on the other hand was originally designed using pessimistic model but due to performance problems in it an option was later provided in sql server to enable optimistic concurrency control. READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count from www.red-gate.com Depending on your application this can either be a good or a bad thing. To find spid which cause same , you can refer below query. Once enabled, all transactions in this database are executed under read committed snapshot isolation and the setting read uncommitted on session level will not be honored.