Transaction and Concurrency Management

Summary -

This lecture covers the concepts of multiple users and dealing with large scale databases. Transaction management and concepts of how bad transactions occur are also discussed - including locking, isolation and transaction errors.

Useful Information and Articles

Transaction Management - Wikipedia article on basic concepts of transactions. You do need to know this basic information.

Transaction Management Syntax in SQL Server - This is the primary syntax for handling transactions in SQL Server.

Rollback Syntax in SQL Server - How a Rollback works, basic syntax and results of a rollback.

 Setting Transaction Isolation Levels in SQL Server  

 MSDN Reference for setting Isolation Level Locking 

 Technet article on setting Transaction Isolation Level