Understanding Statistics in SQL Server
Level: Intermediate
Description:
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 Bio:
Deepthi is a Database administrator with 7 years of experience. She completed her Masters in Computer Technology at Eastern Illinois University and she is a Microsoft certified trainer and Microsoft certified solution expert (MCSE). You can find her blog at dbanuggets.com and follow her on twitter: @dbanuggets
No responses yet