New to SQL Server? This simple tutorial shows how to create a Temporary Table and a table variable, how to query them, and how long each one lasts.
What is the Initial Size of TempDB? – Interview Question of the Week #120
Question: What is the Initial Size of TempDB? Trust me, this question is way more complicated than you read in one line.
SQL SERVER – Unable to Start SQL Service – OS Error 5 (Access is denied.) for TempDB
I moved TempDB files and SQL Server would not start, with OS Error 5 (Access is denied). The message was misleading, and here is the real mistake.
SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files
Shrinking TempDB kept failing: DBCC SHRINKFILE said the page could not be moved because it is a work table page. Here is the workaround that helped.
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
A client’s TempDB log grew to 80 GB while the data file was 5 GB. Here is the script I used for monitoring TempDB Space usage and finding the cause.
SQL SERVER – TDE Effects on TempDB’s Slow Performance
A client had slow performance out of nowhere. The cause was TDE effects on TempDB after someone tested encryption on production. Here is what I learned.
Moving TempDB to New Drive – Interview Question of the Week #077
A 1 AM call: TempDB was full on the C drive. Here is the popular interview question on moving TempDB to new drive, with the steps I use.