Here is another popular lab from Hands-On-Lab library: SQL Server DML Optimization.
DML operations are most frequently used operations in SQL Server to perform data insertion or data update. While dealing with huge data, it is necessary to know the ways using which we can optimize the performance of data insertion and data updates. This lab shows us the techniques to optimize the DML operations. In the first exercise, we will learn about last page contention problem and how to resolve it. In the second exercise, we will learn to optimize the data inserts using table partitioning. In the third exercise, we will learn about the Halloween Problem.
Exercise 1: Optimizing Data Insert – Last Page Contention Problem
Exercise 2: Optimizing the Data Insert Using Partitioning
Exercise 3: Halloween Problem
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.