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.

Subscribe to Download

File Size841.19 KB
Create DateApril 3, 2017
Last UpdatedApril 3, 2017