Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.
Paul White (@SQL_Kiwi) has put together a fantastic series on concurrency, the ACID properties of statements and transactions, and isolation levels in SQL Server.
