Before we begin, I would like to post a link to Craig Freedman’s blog, where I found the following query which has a table spool and an index spool.
?View Code TSQLUSE AdventureWorks;
WITH DirectReports(ManagerID, EmployeeID, EmployeeLevel) AS
SELECT ManagerID, EmployeeID, 0 AS EmployeeLevel
Continue reading […] Spool – query your cached plans […]