Andy Novick discusses the reasons that SQL Server 2000 decides to recompile a stored procedure and demonstrates the tools and techniques that you can use to monitor recompilation. Read the article, watch the movie!

This story continues at http://www.databasejournal.com/featu...le.php/2203601