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 operationsUwe Ricken 400