[dba-SQLServer]Union query disk space

Francisco H Tapia my.lists at verizon.net
Mon Mar 17 15:24:32 CST 2003


ouch that is a problem,  Do you have another disk on that server?  if so
maybe try moving the tempdb over to that disk in order to enable your query
to run.

-Francisco
http://rcm.netfirms.com

On Monday, March 17, 2003 1:08 PM [GMT-8],
Fred Hooper <fahooper at trapo.com> wrote:

: I need to combine data sources that feed a BI program (Cognos). The
: equivalent process with pure SQL Server would be to have a view that
: SELECTs from another view containing multiple UNIONs. My question is:
: Will this result in a table in TempDb representing the UNION'd tables?
:
: If so, I don't have enough disk space. I'd rather not try it out
: blind, do I'm grateful for any ideas.
:





More information about the dba-SQLServer mailing list