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,221 reads
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
380 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,145 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
19,373 reads
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,215 reads
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,182 reads
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
2008-06-03
14,940 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Comments posted to this topic are about the item Running a Service
Comments posted to this topic are about the item Creating Two Keys
Comments posted to this topic are about the item Stairway to DAX and Power...