Here is another popular lab from Hands-On-Lab library: Concurrency Problems in SQL Server
If multiple users access the same data concurrently in the absence of locking, then concurrency problems occur. The exercises include Lost Updates, Dirty Read, Non-Repeatable Read and Phantom Reads. This lab describes all the problems and how to solve them using different isolation levels.
Exercise 1: Lost Updates
Exercise 2: Dirty Read
Exercise 3: Non-Repeatable Read
Exercise 4: Phantom Read
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.
Happy Learning – The Practical Way.