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.