What is a WorkTable in SQL Server? Run a simple CROSS JOIN with STATISTICS IO on and you will see one. Here is what it is and why SQL Server creates it.
SQL SERVER – How to Remove TempDB File?
A DBA accidentally added an extra TempDB file and was not allowed to use SSMS to undo it. Here is how to remove a TempDB file with T-SQL only.
SQL SERVER – How to Create A Global Temporary Table?
Readers asked me to cover it after my temp table post. Here is how to create a Global Temporary Table and how it differs from a regular temporary table.
SQL SERVER – How to Create Table Variable and Temporary Table?
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.