EXEC sp_query_store_set_hints @query_id=6, @value = N'OPTION(RECOMPILE)'; GO After executing that statement, every time the stored procedure is executed, the engine will generate a new execution plan.

Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do. Simply follow the steps here: Click on New Query ...

In an earlier column, I suggested that one way to speed up your application was to reduce the trips you make to your database, specifically by avoiding calling a stored procedure multiple times. To ...

Stored procedure XML This screenshot lists the source of a SQL Server 2014 stored procedure hitting the AdventureWorks2012 database, selecting data from the Customer and SalesOrderHeader tables.