There are three types of temporary tables in SQL Server. The local temporary table, the global temporary table and the table variable.
Everyone of them has a use case and advantages and disadvantages.

First things first. Despite popular belief ALL three types are stored in tempdb. We will prove that so you don't have to ....

continue reading