How do SQL Server Temp Tables Work? SQL Server temp tables are stored in the tempdb database. They are physically created in the same way as regular tables, except that they are named with a pound ...