Checkout the part-2 of my two part article series on SQL Server Transactions and Locking here, in which you will learn how to manage transactions, how to set the transaction isolation level, and how some isolation levels use locking, while others use row versioning.

This article is published on SQL-SERVER-PERFORMANCE.COM.