Kimberly L. Tripp wrote an excellent article explaining the new snapshot isolation in SQL Server 2005.