Statistics: How to Prove Everything but the Truth

Presenter: Kevin Goode, Inmar Inc.

Session 14: September 16 at 13:00 GMT

Session Details

“Like other occult techniques of divination, the statistical method has a private jargon deliberately contrived to obscure its methods from non-practitioners.” Ashley-Perry Statistical Axioms

Statistics are the lifeblood of a cost-based optimizer such as SQL Server’s and are a key component of performance tuning. This session will attempt to demystify statistics in regard to the SQL Server query optimizer. The internals of statistics will be examined and explained so that you will understand what statistics are available, how the optimizer uses those statistics, what causes statistics to be recomputed, and when it happens.

About the Speaker

Kevin Goode has 15 years of IT experience, 12 years of which have been focused on SQL Server, starting with version 6.5. He has worked in many industries, including manufacturing, distribution and logistics, financial services, and IT outsourcing, and has worked for several Fortune 500 companies. His specialties include SQL Server development, performance tuning, Business Intelligence, and ETL.

Register now for 24 Hours of PASS!