SQL Server 2005 documentation. DUH! This one is listed just to see if you are paying attention.
White paper on SQL Server 2005 Beta 2 Snapshot Isolation, by Kimberly L. Tripp.
Expert One-on-One Oracle, by Thomas Kyte (ISBN: 1590592433). This one is listed to please the DBAs who wear multiple hats.