Oct 22, 2022
It's all about TempDB
It’s all about TempDB
Temporary user objects that are specifically created are stored in the tempdb system database, which is a global resource. They consist of temporary stored procedures, global or local temporary tables and indexes, table variables, tables returned in table-valued functions, and cursors. It only has a lifespan equal to the length of a SQL Server session. When compared to other databases, Tempdb’s…
View On WordPress