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,257 reads
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
382 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,185 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
20,343 reads
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,506 reads
Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.
2008-06-13
3,187 reads
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
2008-06-03
15,052 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
I've been exploring various methods to monitor and alert for long-running queries in SQL...
Hi everyone I need to find the last business of the week. In most...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers