Database development and administration require temporary objects for ETL, staging, data processing, and many other common tasks.

In this session, we will delve into temporary tables, table variables, and memory-optimized table variables, as well as memory-optimized TempDB metadata, discussing their differences, how they work, and the optimal scenarios for using each of them.