(Ravi Okade) SQL Server 2005 implements a new feature called Snapshot Isolation or Row Versioning. If implemented on a suitable database, it has the potential to eliminate data contention in your database. It will reduce deadlocks, lock contentions and session waits if appropriately implemented.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help