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


Version1.0
Download0
File Size841.19 KB
Create DateApril 3, 2017
Last UpdatedApril 3, 2017
Logical and Physical Query Processing in SQL Server
Web and Social Analytics Dashboard in Power BI