Here is another popular lab from Hands-On-Lab library: SQL Server Deadlock Types.
A deadlock occurs when two or more sessions permanently block each other with each session having a lock on a resource, the other session is trying to lock. In this Lab, we will learn about three different types of deadlocks.
– Conversion Deadlock
– Cyclic Deadlock
– Foreign Key Deadlock
Exercise 1: Conversion Deadlock
Exercise 2: Cyclic Deadlock
Exercise 3: Foreign Key Deadlock
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.