Developers and DBAs with at least 4 years of experience with T-SQL, indexes and query plans
You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?
In this session we will analyze common use cases of poorly performing queries, such as improper use of scalar functions, inaccurate statistics and the impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced but practical techniques. By the end of this session, you’ll have many powerful techniques to apply to solving query performance issues.
Why I Want to Present This Session:
I just love query tuning. I have been doing it for the past 20 years, and I still love the feeling of reducing a query execution time from 36 seconds to 420 milliseconds.
Latest posts by Guy Glantser (see all)
- Advanced Query Tuning Techniques - January 14, 2018
- How to Use Parameters Like a Pro and Boost Performance - April 21, 2017