How much memory does the server have?

-----Original Message-----
From: Alec Wood
[mailto:mssqldba-ezmlmshield-x24296348.[Email address protected]
Sent: Monday, March 31, 2008 5:44 AM
To: LazyDBA Discussion
Subject: Derived table, or Tempdb

Hi All



I have to produce a report monthly for a customer



Doing so will require producing a few temporary tables.



Is it best practice to use derived tables (nested queries) or to create the
tables in tempdb and then run a query on them







Alec Wood










No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page