MAY 2021 PSSUG Meeting
Event Information
Event description
MAY 2021 PSSUG Meeting
About this event
-->> This Is an ONLINE-Only Event <<--
IMPORTANT:
The meeting will be held on Zoom. The information you need to join will be sent out a few hours before the event. However, we recommend to download and install the app now.
(https://zoom.us/download)
Agenda
Abstract: Cardinality Estimates in SQL Server
Are you new to performance tuning and confounded by statistics? Do you wonder where these statistics come from, and how the optimizer gets the estimates from statistics?
Join me as we dive deep into cardinality estimation, how SQL Server uses statistics to build execution plans, where to find information about how statistics got used and why managing statistics is vital to performance.
This session will have awesome demos showcasing practical examples of how the optimizer uses statistical information for all those crazy queries you write..
Speaker: Deepthi Goguri
Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com. You can contact her on Twitter @dbanuggets