Locking and Blocking – When Read Queries Block Write Queries Demo
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Great stuff Erik, love your work.
Just wanted to know if this behaviour is when RCSI enabled as well?
Thanks!
Hey Joe – no, both Read Committed Snapshot Isolation and Snapshot Isolation spare you this particular misery.