Tempdb Database • • 10 minutes to read • Contributors • • • • In this article THIS TOPIC APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server or connected to SQL Database. Introduction To Architecture Ching Pdf. Tempdb is used to hold: • Temporary user objects that are explicitly created, such as: global or local temporary tables and indexes, temporary stored procedures, table variables, Tables returned in table-valued functions, or cursors. • Internal objects that are created by the database engine. These include: • Work tables to store intermediate results for spools, cursors, sorts, and temporary large object (LOB) storage. Fingerprint Security Software. • Work files for hash join or hash aggregate operations. • Intermediate sort results for operations such as creating or rebuilding indexes (if SORT_IN_TEMPDB is specified), or certain GROUP BY, ORDER BY, or UNION queries. Mapas Gps Navcity.