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
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,341 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
391 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
8,230 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
22,149 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
17,815 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,238 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
15,308 reads
Blogs
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Forums
Life Moves Pretty Fast
Comments posted to this topic are about the item Life Moves Pretty Fast
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers