Like this article? We recommend
Summary
The Snapshot Isolation feature is a cool new feature introduced in SQL Server 2005. Implementing it in your database might provide improvements in data availability. It reduces data contention and guarantees that writers do not block readers, and vice versa. You need to evaluate whether it is appropriate for your database by comparing the costs versus benefits.