The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

SQL Server Statistics and the New Cardinality Estimator – sponsored by Hewlett Packard Enterprise

Wed, May 10 2017 18:00 UTC

SQL Server Statistics and the New Cardinality Estimator – sponsored by Hewlett Packard Enterprise

Statistics in SQL Server play a major role creating execution plan which essentially decides server performance. If you get a good execution plan, the server performance is good otherwise, it will impact negatively on the server performance. SQL Server 2014 introduced a new Cardinality Estimation (CE) model to improve the quality of the execution plans via quality estimates of row counts. The new CE model is the first major redesign to the Query Optimizer since SQL Server 7.0. In this session, I'm going to talk about how statistics are used to generate the execution plan and show demos of how execution plan changes with new CE.

Susantha Bathige

Susantha Bathige (MSc, MCITP) is a Microsoft Certified Database Professional specialized in relational database product, MS SQL Server. Having more than 16 years of IT experience including more than 9 years in database development and administration in non-production and production environments. He has experience of other databases systems such Cassandra and MongoDB as well.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top