Most of you know already, but...

The issue is a matter of persistence, indexing and scope.  On the subject of persistence, memory tables are dropped when the SPID finishes...