https://www.simple-talk.com/sql/learn-sql-server/showplan-operator-of-the-week-lazy-spool/

SQL Lazy Spool Eager Spool