Mastering DML Operations like a master

Speaker: Uwe Ricken

Duration: 1 hour

DML operations mean lots of work for the database engine of Microsoft SQL Server. Understanding the details of a transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations.

This session will demonstrate the huge difference of allocation data in a heap and in a clustered index. If you don't know the benefits of correct record size and / or you are wondering how you could release allocated data pages in a professional way this session may give you all the answers. - data page allocation and its difference for heaps and clustered indexes - what is the amount of translog when you update data in a heap and/or in a clustered index - delete data from a heap and what is the huge difference to a clustered index? - speed up ETL processes by usage of the right strategy for INSERTS and DELETES - Page Splits vs. Forwarded Records - do you really need a clustered index in a table? Pro's and Con's of clustered indexes for DML operations

Uwe Ricken  400