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,379 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
401 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,264 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,954 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,893 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,290 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,474 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Setiabudi Tlpn/wa:085373737551
Jl. Setia Budi No.150 A-B, Tj. Rejo, Kec. Medan Sunggal, Kota Medan, Sumatera Utara...
BCA KCP Rahmadsyah Tlpn/wa:085373737551
Jl. Rahmadsyah No.140 - 142, Kotamatsum III, Kec. Medan Kota, Kota Medan, Sumatera Utara...
BCA KCU BUKIT BARISAN Tlpn/wa:085373737551
Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers