Join us as SQL Server MVP, Alejandro Mesa shares his knowledge about SQL Server 2008 Execution Plan Caching and Reuse:

In this presentation, Alejandro going to talk about how batches are cached and reused (SS 2005 / 2008), and a review of best practices on maximizing reuse of cached plans.

Title: Plan Cache Concepts and Reusability

Agenda:

- Plan Cache and Type of Cached Objects
- Plan Handles
- Cache Lookup
- Query Parameterization
- Plan Cache Metadata
- Best Programming Practices (for plan reuse)
- Plan Cache Flush

Speaker's Bio:

SQL Server MVP, Alejandro Mesa, is CSSUG member and a database developer at Bank of America. He has been a SQL Server MVP since 2007, and has been working with SQL Server for almost 10 years (6.5, 7.9, 2000, 2005, and 2008).

Agenda:

5:30 PM Networking and Pizza

6:15 PM Presentation

7:40 PM Meeting end

The meeting is being held at the Microsoft Offices. Enter the building on the right at the first entrance and ask for the Mt Everest / Mt Kilimanjar rooms.