Caching and reusing query plans is both a good thing and a bad thing. Saving costs of recompilation for a query that is run repeatedly can be a good thing. Using a cached plan that is not appropriate can be a very bad thing. What do you do if you have plans in cache that should not be there? SQL Server 2000 and 2005 provide a way to clear ...