» Transact SQL
» Myth Busting (RSS)
Sorry, but there are no more tags available to filter with.
This came up on sqlservercentral.com, where I read the following claim (in a discussion thread, not in an article): ''COUNT(*) is only guaranteed accurate if your isolation level is REPEATABLE READ, SERIALIZABLE, or SNAPSHOT''. I have a repro script which shows how COUNT(*) running under REPEATABLE READ returns wrong results with high ...