Platinum Sponsor

Understanding Graphical Execution Plans

There are many times when a developer realises that this snippet is not performing the way it was expected to . This happens as early as dev or unit testing cycle . This is the best time to get hold of those performance bottlenecks by using the most accessible performance tuning option "The Graphical Execution Plan".
 
It is a one click operation to get to the plan but the terms like Seek, scan , Book mark Lookup , RID lookup and many more soon start puzzling the developer.

This session is aimed at making the developer aware of those terms and using this knowledge decipher the plan.
Presented by Ashwani Roy at SQLBits IV
  • Downloads
    Slide deck available Slide Deck 497 KB
    Video available WMV Video 107 MB
  • SpeakerBIO
    ashwani_roy.jpg
    I am SQL Server MVP and SQL Server Business Intelligence and C# consultant at CodePerfect Limited .  I am also a regular speaker in SQL Server and BI conferences in UK.
    I have worked with SQL Server BI stack since 2003 and I am Microsoft Certified IT Professional. My main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.
    http://codeperfect.co.uk
  • Video