Browsing All Posts published on »June, 2008«

Refreshing Stored Procedure Cached Plan

June 26, 2008


A nice and easy one but worth sharing. We had an issue on our dev environment where the stored procedure managed to get a really yucky query plan, to resolve this you can DROP and CREATE the procedure or you can use sp_recompile. To use , you call sp_recompile with the object name you want […]