Still not using RCSI?

If you still leave your databases at default settings, namely default isolation (READ COMMITTED – does it suck?), you are risking three things:

  • increased blockage and deadlocks
  • NOLOCK hints or READ UNCOMMITTED transaction isolation in the code, exposing users to dirty read issues
  • wrong results!

The third one – wrong results, is the most serious one. We all want to believe our databases are reliable source of correct data. But if you are still at default database settings (not using RCSI), this demo will show you the risk of getting wrong result from SELECT. Plain wrong, like 2+2=5. Imagine unreliable financial reports – can you afford NOT having RCSI on your database? I think RCSI should be default and enabled on every database, no exception.


Leave a Reply

Your email address will not be published. Required fields are marked *


This site uses Akismet to reduce spam. Learn how your comment data is processed.