Jeff Moden (5/17/2012)
SQL Kiwi (5/16/2012)
Craig Freedman has a couple of great posts covering how recursive CTEs work:http://blogs.msdn.com/b/craigfr/archive/2007/10/25/recursive-ctes.aspx
http://blogs.msdn.com/b/craigfr/archive/2007/11/07/recursive-ctes-continued.aspx
I do wish folks would do a comparison against the equivalent While Loops to see just how bad recursion can actually be for reads and CPU.
I must confess I am a little unsure how your comment relates to the post you quoted. Dwain expressed an interest (at the end of the article) in finding out more about how recursive CTEs work ("Now if I can only figure out how these pesky recursive CTEs really work, then I could post something really interesting!") so I pointed him to the best reference I know of.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi