Recompile a stored procedure – SQL Server

After performing any maintenance activities and bulk updates  or inserts , recompiling the stored procedure or updated table will create new plan and give performance advantage.

sp_recompile ‘object_name’

——Script to recompile all the stored procedures on table.

USE AdventureWorks2012;

GO

EXEC sp_recompile N’Sales.Customer’;

GO

——- Script to recompile a specific stored procedure

USE TestDB;

GO

sp_recompile ‘sp_salesorders’