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,267 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,194 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
20,643 reads
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,579 reads
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,189 reads
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
2008-06-03
15,094 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers