Nice article. Cleared a lot of grey areas regarding CTE for me.

I have a doubt though, given the uses of a CTE, isint it similar to table variables then? I mean where is the result stored and how performant is a CTE as copmared to a table variable.

Pardon my ignorance if I am asking a question which should have an obvious answer.