Bad Plan! Sit!
Bad execution plans are the bane of database performance everywhere they crop up. But what is a bad execution plan? How do you identify one in your system and, once identified how do you go about fixing it?
In this session we’ll look at some things that make a plan ‘bad’, how you might detect such plans and various methods of fixing the problem, both immediately and long-term.
Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization. Gail works for Entelect, a medium-sized custom software development house based in Johannedburg. Gail is a frequent poster on the SQLServerCentral.com forums and writes for Simple-Talk. She is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server