How Table Variables Can Speed Up Your Queries

When trying to implement complex data handling in SQL, very often developers use temporary tables. The newer versions of SQL support tables as variables. As you know, temporary tables get stored into tempdb and, theoretically variable – tables get stored and executed in memory, but eventually reach to HDD if there it is not enough memory. What’s better to use and when? Here's just an example.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro05/html/sp05b7.asp