PASS Summit 2010
Register Now

ROI Justification

Sponsors

Questions?

PASS Facebook PASS LinkedIn PASS Twitter


Premier Sponsor:
  

Platinum Sponsor:
  
Identifying and Fixing Performance Problems using Execution Plans
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 different methods for addressing the issues and show how the fixed query's execution plans differ. Multiple methods for accessing execution plans including graphical, DMV's, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.
Speaker:
FM Global
Principal DBA
I am a database administrator for FM Global, an engineering and insurance company. I have 20+ years experience in IT including time spent in support and development. I have been working with SQL Server since 6.0 back in 1995. I have developed in VB, VB.Net, C# and Java. I volunteer at PASS with the Editorial Committee. I'm the serving president of the Southern New England SQL Server Users Group (SNESSUG). I was awarded as a Microsoft SQL Server MVP in 2009 and 2010.
Register Now for PASS Summit 2010!


 
  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!
 
 

Gold Sponsor

     
     
Copyright 2010 by PASS | Terms of Use | Privacy Statement