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.

Regular Meeting Schedule

The DBA Virtual Chapter 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. In alternate months (May, July, Sept etc.) there is an additional meeting at 8:30 PM Eastern. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

Filtered Statistics

Wed, Jun 14 2017 12:00 Mountain Daylight Time

RSVP: None

Filtered Statistics

Statistics in SQL Server play a major role deciding the shape of the Execution Plan. The execution plan is ultimately responsible for the query performance. Filtered statistics is a type of statistics in SQL Server which you can use to influence the query optimizer by providing more information to it so that Query Optimizer could produce a quality execution plans. Filtered statistics was introduced in SQL Server 2008 but in my opinion, it has not got the attention it needed yet. In this presentation, I will demo the use of filtered statistics to improve the cardinality estimation.


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.

Meeting Recordings

The DBA Virtual Chapter 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.

Interested in Presenting to the DBA VC?

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, dbavolunteer@sqlpass.org.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids