Encourage. Energize. Empower.

Please join PassWIT at these upcoming webinars hosted by our fellow Virtual Chapters

Next Meeting

Tue, Aug 04 2015 11:00 Central Daylight Time


DBA Fundamentals - Gail Shaw

RSVP: https://attendee.gotowebinar.com/register/2045985897824759553

What Execution Plans can tell you about Query Performance

You have badly performing queries. Doesn’t everyone? You’ve done the investigation, you’ve identified a handful of slow queries that need tuning, you’ve got the execution plan and… Now what? In this demo-heavy session, we’ll look at what the execution plan can tell you about your query performance. We’ll look at several common operators in query plans and their properties and what they mean. We’ll point out a number of red-flags that can be found within the execution plan and we’ll show how to use the information from the plan to tune the query. All queries shown in this session will be based on ones seen in real-world production systems in the last few years.


Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization. Gail works for Entelect, a medium-sized custom software development house based in Johannesburg. Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server.

SQL Saturday WIT Events

Is your SQL Saturday organizing a PASS WIT panel session?  If so, let us know! Has your SQL Saturday team recently hosted a PASS WIT Panel session? Share your pictures, thoughts and experience with us! Email us at WITinfo@sqlpass.org

Upcoming Events:

Many upcoming SQLSaturday events will feature Women in Technology panels or discussions. Check out our calendar for details.