• Read this http://www.sqlservercentral.com/blogs/scarydba/2009/09/09/spools-in-execution-plans/

    If spooling happens, it will show in the execution plan.

    https://sqlroadie.com/