This seventh webcast in our series on Microsoft SQL Server development focuses on ways you can optimize your stored procedures and how to make the most of the resources you have available. What happens when you execute a statement? If a plan is used, how long does it stay in cache? Can you control caching. or the length of time a plan is kept in cache, or even what plan is placed in cache? We compare and contrast dynamic string execution, sp_executesql, and stored procedures, and examine how ...

MSDN Webcast: A Primer to Proper SQL Server Development (Part 7 of 10): Understanding Plan Caching and Optimizing Procedure Performance (Level 200)