october, 2019

tue22oct6:30 PM8:00 PMI will speak at SQL PASS KoblenzIdentify missing indexes in Microsoft SQL Server6:30 PM - 8:00 PM prosozial GmbH, Emser Str. 10, 56076 Koblenz, Germany

Abstract

In this session (level 300), we develop a strategy to implement the right indexes for an existing workload to reduce overall costs.
For this we compare the various features such as Dynamic Management Objects, Query Store and Database Tuning Advisor and evaluate the accuracy of the index recommendations.