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,350 reads
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
2008-07-18
8,249 reads
This article describes how to generate the sp_who2 results including the query text for the spid.
2008-06-26
22,650 reads
This article describes how to use variables in SSIS to dynamically generate folders and file placement.
2008-06-17
17,871 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,395 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;