Name: 13 optimizer statistic problems you didn’t know you had ~ Fabiano N Amorim
Start: 2025-02-12T12:00:00-05:00
End: 2025-02-12T13:00:00-05:00

WHEN:
Wednesday, February 12, 2024, 1700 GMT

DESCRIPTION of TALK

Title: **13 optimizer statistic problems you didn’t know you had**
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 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.

We’ll discuss about things like:
\- How can I have a CXPACKET wait on this query using OPTION\(MAXDOP 1\)?
\- Why is this query compilation taking so much time?
\- What are the problems of columnstore and stats?
\- How to improve the time it takes to run update stats with fullscan?
\- Why my index rebuild is not running update stats with fullscan?
\- Bad tracking of statistic modification counter\.
\- Cases with inaccurate cardinality estimation due to non\-optimal usage of statistics\.
\-\- Temporary tables caching\, missing optimization available on TF4199\, missing stat column warning\, inaccurate estimation using avg_range_rows\, filtered statistics…

And much more…

Taiob Ali

Julie Bloomquist

Surbhi Pokharna

Paresh Motiwala

Database Professionals Virtual Meetup Group

Azure Data Tech Groups

Technology

Database Administrators

SQL Azure

Database Professionals

Microsoft Azure

Database Development

Data Management

Big Data

NoSQL

Data Science

 **Pythian - Principal Consultant**
Fabiano loves to conquer complex, challenging problems—especially the ones that others aren’t able to solve. He first became interested in technology when his older brother would bring him to his work meetings at the age of 14. With over a decade of experience, Fabiano is well known in the database community for his performance tuning abilities. When he isn’t working, he loves to read and spend time with his wife and son. He also is a data platform MVP since 2011 and actively involved in SQL Server community though forums, writes articles for Simple-Talk ([https://www.simple-talk.com/author/fabiano-amorim/](https://www.simple-talk.com/author/fabiano-amorim/)), and he also presents online Webcasts and In-Person events around world. His blog is on [http://blogfabiano.com](http://blogfabiano.com/) and you can follow him on twitter at @mcflyamorim.

Fabiano Neves Amorim

13 optimizer statistic problems you didn’t know you had ~ Fabiano N Amorim

Online event

Share

Database Professionals Virtual Meetup Group

13 optimizer statistic problems you didn’t know you had ~ Fabiano N Amorim

Database Professionals Virtual Meetup Group

Details

Members are also interested in