This article from SQL Performance is sharing the contrast between the SQL table variable and temporary table in term of performances, the way it being cached, and when to use it. Read more...