Summit video library

Another 13 optimizer statistic problems you didn’t know you had

Fabiano Amorim

After two consecutive best ranked (based on survey results) presentations about SQL Server statistics on PASS Summit 2022 (Your Ultimate SQL Server Statistics Best Practices Review) and 2023 (13 Optimizer Statistic Problems you Didn’t Know you had). I’m back to Seattle to delivery another session about statistics.

SQL Server QO (query optimizer) and CE (cardinality estimation) are derived primarily from statistics. For most of the time, QO does a very good job using statistics to create a high-quality query plan; but, in some cases, you may see unexpected situations where it didn’t work quite well.

In this session, we’ll explore another 13 different cases with an unusual behavior related to SQL Server statistics. The idea is to understand what happened, what to do, and increase your knowledge on query performance troubleshooting.

A Simple Talks session.

Get the Latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit (in line with our Privacy Policy) unless you separately request emails about Redgate. You can unsubscribe from these updates at any time.