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
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
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,349 reads
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
392 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,245 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
22,603 reads
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,866 reads
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,270 reads
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
2008-06-03
15,384 reads
By gbargsley
Are you diversifying your DBA skillset? My recent job search made one thing clear:...
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Comments posted to this topic are about the item Vector Datatype
Comments posted to this topic are about the item PRs Are Like Trouble Tickets
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers