Advanced Query Tuning Techniques by Guy Glantser

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.

You can listen to Advanced Query Tuning Techniques by Guy Glantser online on Radio and Podcast. Open the player on this page to stream the available audio.

Advanced Query Tuning Techniques by Guy Glantser is an episode from GroupBy – Free SQL Server Training by Brent Ozar.

This episode is 01:09:33 long.

This episode was published on Jun 26, 2018.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.