22-25 April 2026

Transient data in SQL Server

2008

TL; DR

Transient data in SQL Server

Session Details

This session is focused on transient data in SQL Server. We will look at questions like: What is stored in tempdb? Is tempdb a performance bottleneck? What are the differences between temporary tables and table variables? What is stored in the transaction log file and how can its size be kept under control?

3 things you'll get out of this session