Session

BOS28-200: Maximizing Plan Re-use in SQL Server
Presenter: Andrew Kelly
Breakout Session - Level 200 (Intermediate)

Lack of plan reuse is one of the biggest performance killers in SQL Server and almost everyone has experienced problems in this area before. We will explore exactly how to determine if this is an issue for you and more importantly, how to address it. See what factors determine if a plan gets reused or not and why. We will cover how to issue calls to the database that guarantee reuse and peak performance. Understanding this aspect of SQL Server is something every good database developer should be fully aware of and attending this session will get you the insight to get started immediately.

Code and Slides

Microsoft Most Valuable Professional (MVP) logo Andrew Kelly
Partner, Solid Quality Mentors
Andrew J. Kelly is a Partner & Mentor with Solid Quality Mentors and lives in Myrtle Beach, South Carolina. He has over 20 years experience with relational databases and application development on both UNIX and Windows platforms but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups and has been a SQL Server MVP since 2001.

Email: akelly@solidq.com
Website: http://www.solidq.com
Blog: http://sqlblog.com/blogs/andrew_kelly/default.aspx
Twitter: http://twitter.com/gunneyk