Two Of My Favorite NOLOCK Demos from Paul White and Aaron Bertrand
Erik has covered transaction isolation levels lately in videos. The first demo from Paul White shows an issue where queries stop scanning due to data movement. The second demo from Aaron Bertrand comes from this blog post.