addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupsimageimagesinstagramlinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1outlookpersonJoin Group on CardStartprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Triangle SQL Server User Group Meeting

You are cordially invited to the next meeting of the Triangle SQL Server User Group to be held on February 19 at TEK Systems in Raleigh, NC from 6:30 PM to 8:30 PM.

Local TriPASS sensation Dale Burnett will  present:

SQL Server Statistics - Cardinality, Density, Sample Size, and Filtered Indexes

Unlike most presentations on statistics, which focus on maintenance and upkeep, I want to delve into how SQL Server uses stats to develop cardinality estimates which are ultimately responsible for the query plans produced. I'll likely also touch on a few other odds and ends that are rarely discussed.  I have found that knowing how the optimizer estimates cardinality to be very useful in targeting performance optimizations and fixing bad cardinality estimates. Grossly incorrect cardinality estimates can have huge downstream performance effects especially on hash and sort operations.

Part 1 - What are stats good for

Part 2 - Density

Part 3 - Histograms

Part 4 - Multi-Column cardinality estimates

Part 5 - Strings and sub strings

Parts 6+ - Computed columns, magic density, sample size and accuracy


Dale has worked with SQL Server from 1998 til 2002 starting with 6.5 and touching 2000 at the end of that period and was responsible for data modeling and development, creating custom databases and applications for many clients. In 2007, Dale took a break from SQL Server until 2007. Since then, he has been doing primarily SQL Server development, some data modeling, performance optimizations and light administration.  He currently work for a financial services firm.

Let's come out and give Dale all the support we can muster.  I look forward to seeing you all there!


Join or login to comment.

  • Shashikanth P.

    Are there any recordings available for these meetups, so new ppl in this group like me can go through them :-)

    January 6, 2014

Our Sponsors

  • TEK Systems

    TEK Systems provides space for our meetings as well as food and drink.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy