SentryOne Team Blog (

Category : tempdb

Paul White : SQL Server Temporary Object Caching

Paul White : SQL Server Temporary Object Caching

Paul White (@SQL_Kiwi) describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.

Slide decks and demos from #SQLDay Poland

Aaron Bertrand (@AaronBertrand) shares his PowerPoint files and SQL samples from his Bad Habits and tempdb sessions at SQLDay in Wrocław, Poland.

Paul Randal : Knee-Jerk Performance Tuning : Temp Tables

Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.

Investigate TempDB Like Sherlock Holmes

Richard Douglas (@SQLRich) shares the slides from his recent session at SQL Saturday Exeter, "Investigate TempDB Like Sherlock Holmes."

Instant File Initialization : Impact During Setup

SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand (@AaronBertrand) looks at how this can impact tempdb data file creation.

SQL Server 2016 : Getting tempdb a little more right

Aaron Bertrand (@AaronBertrand) explains how SQL Server 2016 improves tempdb configuration and performance, and how there is still room for improvement.

Should I use NOLOCK against #temp tables?

Aaron Bertrand (@AaronBertrand) addresses a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.