Hugo Kornelis (8/28/2015)
Jeff Moden (8/27/2015)
Favorite name for a Temp Table when troubleshooting something that should never have made it to production...[font="Arial Black"]#MyHead[/font]
When I want to make sure that my query tuning measurements are not impacted by the time it takes SSMS to render the results, I often redirect the results to a temporary table. And I have a standard name for that table too:
SELECT (something)
INTO #Oblivion
FROM (etc)
I've seen #MyHead several times before, but never INTO #Oblivion. Nice! 😛