Welcome to Aussie SQL Server Bloggers
Sign in
|
Join
|
Help
Transaction blog
This Blog
Email
Calendar
Nov
December 2004
Jan
M
T
W
T
F
S
S
29
30
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
9
Search
Go
Syndication
RSS 2.0
Atom 1.0
Archives
April 2008 (4)
February 2008 (2)
January 2008 (1)
June 2007 (2)
April 2007 (4)
March 2007 (1)
December 2006 (6)
November 2006 (2)
October 2006 (1)
September 2006 (13)
August 2006 (2)
July 2006 (1)
June 2006 (2)
May 2006 (1)
April 2006 (3)
March 2006 (11)
February 2006 (3)
January 2006 (2)
November 2005 (1)
October 2005 (1)
September 2005 (1)
April 2005 (1)
March 2005 (2)
February 2005 (3)
December 2004 (5)
November 2004 (3)
October 2004 (1)
September 2004 (2)
Navigation
Home
Blogs
Photos
Post Categories
Australian SQL Server User Group (4)
Personal stuff (6)
SQL Server - other (6)
SQL Server - Scripts (9)
SQL Server - Technical (19)
Wednesday, 1 December 2004 - Posts
Wednesday, 1 December 2004 7:12 AM
#temp tables and @table variables are NOT in-memory objects
#temp tables and @table variables are often used to optimise stored procedure performance by breaking down large queries (many joins) into smaller units of work or materialising resultsets to perform additional processing logic in isolation from
posted by
Greg_Linwood
|
0 Comments