Object names in SQL Server can be up to 128 characters, but local temp tables stop at 116. Guest author Balmukund Lakhani explains this limit for Temp Objects.
Spotting tempdb Contention
Spot tempdb contention through PAGELATCH waits and allocation pages, then review file layout and current server settings before changing files.
SQL SERVER – TempDB in RAM for Performance
Can you put TempDB in RAM for better performance? A friend asked me this, and here is why SQL Server no longer needs it and what I prefer instead.
SQL SERVER – Reducing Page Contention on TempDB
A reader uses trace flag 1118 to reduce page contention on TempDB and wants my opinion in one line. Here is my one line answer and a question for you.
SQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage
My SQL puzzle: which queries create the most TempDB IO and grow its size? Answer with any DMV, and all valid answers get published here with credit.
Watching the tempdb Version Store
Watch the tempdb version store with per-database space DMVs, find transactions that delay cleanup, and plan capacity from trends.
Storage Settings That Matter for SQL Server
Storage settings That Matter for SQL Server include latency, file placement, allocation unit size, and file growth; learn what to verify.