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