SQL Reuse of plans with sp_executesql

SQL

Download (.zip)

USE Northwind
GO
DBCC FREEPROCCACHE
GO
EXEC sp_executesql N'SELECT firstname, lastname, title FROM employees
WHERE employeeID = @p', N'@p tinyint', 6
EXEC sp_executesql N'SELECT firstname, lastname, title FROM employees
WHERE employeeID = @p', N'@p tinyint', 2
EXEC sp_executesql N'SELECT firstname, lastname, title FROM employees
WHERE employeeID = @p', N'@p tinyint', 6
GO
SELECT * FROM master..syscacheobjects
WHERE dbid = 6

SQLCorrelated subquery with derived table Instead of DELETE trg on VIEW Instead of INSTEAD trg on UNION VIEW
SQLJOINs with dummy rows Problems with old style outer JOINs Reuse of plans with sp_executesql
SQLscript with comments Update in serializable mode with index