It depends on many factors

Number of tables involved
Number of rows returned
Data return
Your criteria




Jaime E. Maccou
mailto:Jaime E. Maccou
"Our lives begin to end the day we become silent about things that matter."
- Dr. Martin Luther King, Jr.
"The mind does not take its complexion from the skin..."
- Frederick Douglass
There is always a way to do it better . . . find it!" Thomas A. Edison

DBA Ethical Rules
1. Don’t Lie
2. Don’t Cheat
3. Don’t Steal
4. Treat everyone fairly
5. Treat everyone equally"


-----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