BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20170407T082000Z DTEND:20170407T093500Z LOCATION:Dome 1, SQLBits 2017, The International Centre SUMMARY:Exploring Statistics: Where estimated rowcount comes from DESCRIPTION:A look inside SQL Server distribution statistics X-ALT-DESC;FMTTYPE=text/html:

Exploring Statistics: Where estimated rowcount comes from

Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll also discuss changes in the cardinality estimator in recent versions and look at some new metadata that gives us more statistics information.  Goals:

Kalen Delaney

Kalen Delaney has been working with SQL Server for over 29 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2016 Internals: In-memory OLTP, from Red Gate.  Kalen blogs at UID:SQLBITS3308SEQUENCE:0 DTSTAMP:20170524T003540Z END:VEVENT END:VCALENDAR