Maintenance of indexes by DMOs

Indexing is one of the most important tasks for a well performing database. An optimized database need to be checked regular for all kind of index problematic. This session will show the usage of DMOs (dynamic management objects) for the maintenance of indexes. The audience will get familiar with the physical thresholds for optimal Indexes; approvement of the usage of Indexes within a few minutes and demonstration of results to the vendors! A deep look into the dmo for the new Column Stored Indexes will be demonstrated, too!
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.