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 Simmons
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
6,988 reads
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
363 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
7,779 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
12,690 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
12,830 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,071 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
13,793 reads
Blogs
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
One table or two?
I have an outside company that will be sending me 2 files each month. ...
Backup file size 3X after shrinking the log file?
Here's a head scratcher - I've not seen anything like this in 20+ years...
Ask SSC