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
7,044 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
376 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,895 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
15,594 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
15,843 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,096 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
14,255 reads
Blogs
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
Are You a Diverse User Group or Event?
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
Daily Coping 18 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Deceptive Visualizations
Comments posted to this topic are about the item Deceptive Visualizations
Argument syntax for SSIS Execute Process Task Editor
Hi, I'm trying to modify my SSIS packages to use sftp and since it...
Seeking input on Best Method to Join on First or Last Row in a 1:M Join
I have included the DDL to re-create the 2 tables in this examples. I...
Ask SSC