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,348 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
392 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,244 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,573 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,863 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,267 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,380 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers