SQL SERVER – Recompile All The Stored Procedure on Specific Table | Journey to SQL Authority with Pinal Dave

I have noticed that after inserting many rows in one table many times the stored procedure on that table executes slower or degrades. This happens quite often after BCP or DTS. I prefer to recompile all the stored procedure on the table, which has faced mass insert or update. sp_recompiles marks stored procedures to recompile… Continue Reading...

Source: SQL SERVER – Recompile All The Stored Procedure on Specific Table | Journey to SQL Authority with Pinal Dave