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.

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

News and Updates

Do you have something to say about the situation of women working in technology? Do you know of an interesting technical woman to interview? We want to hear from you! Contact WITinfo@sqlpass.org with your articles and ideas.