lazy spool Archives - SQLServerGeeks

SQL Server Table Spool Operator (Lazy Spool) – Part3

October 25, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

Hi Geeks, Welcome to the Part3 of SQL Server Table Spool Operator (Lazy Spool). If you reading this post before earlier two posts on the subject, you can click on Part1 and …

SQL Server Table Spool Operator (Lazy Spool) – Part2

October 24, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

Hi Geeks, Today we will explore the first step of execution plan (highlighted in red) in detail and is a continuation of yesterday’s post on SQL Server Table Spool Operator (Lazy …

SQL Server Table Spool Operator (Lazy Spool) – Part1

October 23, 2014July 3, 2020 - by Kanchan Bhattacharyya - 6 Comments.

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 …