Reading from Snapshot Databases With Multiple Tables
If you haven’t explored using Snapshot isolation in SQL Server, I recommend you give it a look. A snapshot enabled database allows the reader to get a clean read without blocking. Prior to this capability, the only way to guarantee a non-blocking read from the database was to sprinkle NOLOCK statements all over your queries.… Read More Reading from Snapshot Databases With Multiple Tables