The Madison SQL Server Users Group (MADPASS) is an official chapter of the Professional Association for SQL Server. We are here to support the SQL Server users in the Madison, WI area. We plan to meet on the third Wednesday of every month.

Meetings are always FREE and food is provided. Details about the next meeting can be found below.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session. Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 5:45 - General Q&A session & Announcements
5:45 - 6:15 - Food &Networking
6:15 - 7:30 - Main Presentation
7:30 -7:45 - Door Prizes&Q&ASession & Wrap-up

Note - Due to the holidays, we are not having a meeting in December. We will return in January with our new MadPASS day - 3rd Wednesdays of the month! (01/17/2018)


Meeting Location Provided By:

Next Meeting




Decoding the Cardinality Estimator to Speed Up Queries

  • In-Person @ 5510 Nobel Drive Fitchburg, Wisconsin, United States (map)
  • Online @ None
  • 17:30 - 20:00 Central Daylight Time

5:30 - 5:45 - Food & Networking

5:45 - 6:15 - General Q&A session & Announcements

6:15 - 7:30 - Main Presentation

7:30 - 7:45 - Q&A Session & Wrap-up

Featured Presentation:

Decoding the Cardinality Estimator to Speed Up Queries

Joe Obbish, Business Intelligence Developer

The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.

About Joe:
Joe Obbish has nearly a decade of experience with SQL Server and other database platforms. He works as a query tuning, columnstore, and scalability expert within Epic, a large EHR and analytics vendor in Madison, WI. In less than two years he became one of the top contributors for SQL Server on the DBA StackExchange community. Joe blogs about advanced columnstore and query tuning topics on his blog, In his spare time, Joe enjoys baking and sharing these treats with his coworkers.

Connect with us!




Office 365 


Back to Top