Alexander Kuznetsov : SQL Deadlocks, Transact SQLhttp://sqlblog.com/blogs/alexander_kuznetsov/archive/tags/SQL+Deadlocks/Transact+SQL/default.aspxTags: SQL Deadlocks, Transact SQLenCommunityServer 2.1 SP2 (Build: 61129.1)Selects under READ COMMITTED and REPEATABLE READ may return incorrect results.http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/04/10/selects-under-read-committed-and-repeatable-read-may-return-incorrect-results.aspxSat, 11 Apr 2009 00:34:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13217Alexander Kuznetsov14http://sqlblog.com/blogs/alexander_kuznetsov/comments/13217.aspxhttp://sqlblog.com/blogs/alexander_kuznetsov/commentrss.aspx?PostID=13217Selects under READ COMMITTED may return incorrect results if the data they select is being modified at the same time. I will provide a repro script which on my laptop returns incorrect results in more than 90% cases. Also I will provide a similar repro...(<a href="http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/04/10/selects-under-read-committed-and-repeatable-read-may-return-incorrect-results.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=13217" width="1" height="1">SQL ServerTransact SQLSQL Deadlocks