SQL Server Table Spool Operator (Lazy Spool) – Part1

Hi Friends, To understand SQL Server Table Spool Operator, let us consider following query as an example. USE [AdventureWorks2012] SELECT SD1.SalesOrderID,SD1.SalesOrderDetailID FROM Sales.SalesOrderDetail SD1 WHERE SD1.OrderQty > (SELECT AVG(SD2.OrderQty) FROM Sales.SalesOrderDetail …

SQL Server Table Spool Operator (Lazy Spool) – Part1 Read More