DML operations in detail

DML is used in most cases without thinking about the multiple operations for the db engine. This session will do a deep dive into the internal storage engine down to record level.

After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated.
SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes

Get aware of the huge amount of transaction log may be generated when a simple page split occurs.
Learn techniques to avoid cost expensive operations
Presented by Uwe Ricken at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    I am working with IT-systems since early 1990's and with the main focus on SQL Server since version 6.0. I started with development of database applications in 1998 with a professional CRM-System based on Microsoft products (Microsoft Office and SQL Server). Since 2008 I'm focused exclusively on Microsoft SQL Server and since 2008 I'm working in 3rd level support for banks, insurances and world wide acting industries. Since May 2013 I'm a Microsoft Certified Master: SQL Server 2008 which was a hard - but amazing - way into the depth of Microsoft SQL Server. Helping others with their problems with Microsoft SQL Server and sharing my knowledge is another passion of me; so you will find me quite often in the Microsoft forums (msdn / technet) for SQL Server. Furthermore I like to speak about Microsoft SQL Server. I'm an IT-Trainer since 1991 and had several acts as speaker on the german PASS and the SQL-Server / .NET Community in Nuremberg (SNEK). In July 2013 I have been awarded with the MVP Award for my activities in the community for the SQL Server product(s). When I'm not working with Microsoft SQL Server I'm writing about my daily experiences with Microsoft SQL Server in my blog. Due to the fact that most high professional blogs are written in english language I decided to publish in german language only to share the deep knowledge about Microsoft SQL Server with the german community. You can find my (german only!) blog at My hobbies are diving, driving my motorcycle and my Italian sport car from Maranello which I own since 1998. One dream is a tour on the road 66 across the USA which - I hope - will come true in 2015.
  • Video
    The video is not available to view online.