Yes, Table Variables and Temp Tables both use the tempdb
Pinal Dave recently wrote a blog post called SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth...
2009-12-18
2,207 reads
Ken Simmons
SQL Server Preproduction Tasks
What are some of the things that you need to do before you sign off and hand it over to production? What do you need to do to keep the server running smoothly?
2008-11-26
6,984 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
363 reads
Return Query Text Along With sp_who2 Using SQL 2000
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
7,765 reads
Return Query Text Along With sp_who2 Using Dynamic Management Views
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
12,445 reads
Dynamically Generate Folders for File Output using Variables in SSIS
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
12,329 reads
Include Column Headers From SSMS
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,071 reads
Sync All Logins on a Server in a single click using SP_MSForEachDB
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
2008-06-03
13,753 reads
Blogs
Quick Blog: Making the Power BI PowerShell cmdlets easier to use
By Aaron Nelson
One of the top reasons I love PowerShell so much is that from the...
Trouble writing? Join the club. #JustWriteTech
By Jen McCown
I was talking with a couple of excellent SQL people* recently, and we were bemoaning...
Check Query Progress with Live Query Stats
This is something I touched on back in 2017 a little after the Live...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
how to list index corresponding to statistics using select statement
Hi , with query bellow I can list DTA statistic that is not updated...
Get files based on SQL results
I have a sql task which queries a database and returns a result set...
Ask SSC