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.
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 #.