Identifying and Fixing Performance Problems Using Execution Plans 4.88 http://spkr8.com/t/4566

Description:

This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including GUI, DMV's, and trace events are demonstrated. This lays a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster.

Comments on this Talk

Headshot_eli2_100 Eli Weinstock-Herman (Tarwn), 19 Sep 11:24 AM

Grant's delivery and content was excellent. He kept the audience involved (even had us stand up and stretch halfway through), constantly invited feedback and interactive comments, and still managed to share a lot of knowledge on execution plans and tuning (despite some demo issues). He presented with a lot of energy, and his enthusiasm for the subject showed clearly.

Avatar-missing-icon-10 Mish, 20 Sep 01:01 PM

Awesome presentation! Other than the few little technical problems running the examples. Oh, a minor criticism, when using the larger font for your queries and trying to show them, make sure to Ctrl+R the results out of the way so the audience can see the statement a bit better. Loved the energy and topic!

Avatar-missing-icon-03 xianchen, 10 May 02:00 AM

Carefully examine the serial variety of each within the bag and within the card. they ought to be matched.<br> Here comes the standard of the bag. The bag material ought to be of excellent quality. you'll simply notice a sort of luster.<br> Don’t forget to seem at hardware of the bag. There ought to be brand engraved within the hardware.<br> The last however not the list factor is to shop for from a well-reputed store. Don’t take risk to shop for this whole baggage from any native store or a brand new on-line store. Before getting from a web store, don’t forget to understand the authenticity of the positioning. Remember, you're reaching to pay a hug usd for a bag.

Have an account? Sign in or register.

Leave a Comment

3 Ratings: 4.88

Delivery: 4.83

Content: 4.93

Time & Location

September 18, 2010 — 01:00 PM
ECPI, 4101 Doie Cope Road, Raleigh, NC 27613 (Map It)