http://blogs.msdn.com/b/sqltips/archive/2007/08/30/spool-operators-in-query-plan.aspxI came across a question in the relationalserver.performance newsgroup where a customer was wondering about the spools seen in a recursive query execution plan. The query is shown below: USE Northwind; Go WITH EmpChart AS ( SELECT EmployeeId, ReportsToen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqltips/archive/2007/08/30/spool-operators-in-query-plan.aspx#8569831Mon, 02 Jun 2008 20:48:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:8569831Ian Beckett<p>Spool operators in recursive query plans</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=8569831" width="1" height="1">http://blogs.msdn.com/b/sqltips/archive/2007/08/30/spool-operators-in-query-plan.aspx#4742369Tue, 04 Sep 2007 17:56:50 GMT91d46819-8472-40ad-a661-2c78acb4018c:4742369Vinod Kumar's Blog<p>Just in continuation to the series over Query tuning and execution plans ... Here is a post by UmaChander</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=4742369" width="1" height="1">