Understanding Statistics in SQL Server by Erin Stellato || SQL Server Virtual Conference

Troubleshooting performance issues and tuning queries in SQL Server can be easier with some level of understanding about statistics. If you want to understand how the optimizer uses statistics when creating a query plan, and why they're so important, then join me for this session. We’ll define what statistics are, examine how the optimizer uses them, and review how to find cardinality estimate information in a plan. We’ll also cover the various ways statistics can be updated, and explore what happens to plans when those updates occur, so you can understand why maintaining statistics is essential for performance. Expect lots of demos so you can fully grasp what statistics are, how they're used, and why their management is so essential for good performance.
About Speaker
Erin Stellato is a Data Platform MVP and lives in Cleveland, OH. She has over 19 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including SQLintersection, SQLBits, and the PASS Summit. Outside of time with family and friends, she enjoys running, reading, movies, and all things chocolate.
Conference Website: www.2020twenty.net/sql-server...
C# Corner - Community of Software and Data Developers
www.c-sharpcorner.com
#statistics #SQL #sqlserver #csharpcorner ##live #virtual #conference

[@LuisALbertoPintado]

It was great profound explanation, thank you so much!

[@ahmadshaik1852]

very well explained. Thank you for sharing!

[@robh115]

thanks for the explanation regarding the parameter sniffing issue. As you said, the data might be skewed and the cached plan might not be suitable. Question is, what is the solution to this problem?

[@loudravetortoise]

Thank you!!!