• There isn't a lot of difference between temp tables and table variables. They'll both spill over into tempdb if the data sizes are large.

    If you have a lot of inserts/updates, you can use a permanent table and it might save you some memory, but depending on how you do things, it's possible that your application should be architected to handle the load better.