HomeSQL ServerHow to prevent blocking in your SQL Server database

Comments

How to prevent blocking in your SQL Server database — 3 Comments

  1. It should be clear to readers that READ COMMITTED can also cause phantom reads an non-repeatable reads, it’s not an RCSI specific problem. RCSI avoids the problem of having to maintain locks for reads as well as writes. Craig Freedman has some great blog posts about weird things that can happen under READ COMMITTED that don’t happen under RCSI.

Leave a Reply

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

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>