Query Plans - Kalen Delaney
Being able to determine how SQL Server is processing your critical queries is the most crucial step in determining what queries are tunable, and how you might begin your tuning efforts. We will cover the basics of displaying various kinds of query plans, both text based and graphical. We will also look at the XML query plan feature available through SQL Server Management Studio.
Kalen Delaney is a SQL Server MVP who has worked with SQL Server for 29 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for years. She is the primary author of "SQL Server Internals" and the "Inside SQL Server" series. Kalen is also one of the primary editors for the Red Gate "SQL Server Stairways" tutorials.
Sponsor: Robert Half Technology
Meeting location info for new members:
2700 Gateway Oaks Drive is located in the Sutter Health business park at the northeast corner of the intersection of Gateway Oaks Drive and West El Camino in Sacramento. The 2700 building is at the back of the complex; you can see I-5 from the parking lot. Enter the building from the parking lot side, not the courtyard side. Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600. In the reception area, check the monitor to find our room for the evening and then proceed to that room.