Refreshing Stored Procedure Cached Plan

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 […]