When Snapshot Isolation Helps and When It Hurts November 3, 2006 ou know SQL Server 2005’s new snapshot isolation feature can help you reduce lock contention and deadlocks, but did you know that it also can help you fix intermittent errors