Stop Indexing the Query!

Robert Mandeville

Learn a new approach to tuning at the object level vs at the query level. I’ll share my methodology and as well as some scripts to find the most impactful workload running in your systems, aggregate it at the object level, and then look for the missing pieces to the puzzle like an index. Stop indexing for a bad query and start indexing for the greater workload. Also, learn how to approximate the cost of adding new indexing – or keeping the ones you have. Use the data that SQL Server already has available to take your tuning and optimizing to the next level.