[dba-SQLServer]Union query disk space

Fred Hooper fahooper at trapo.com
Mon Mar 17 15:08:24 CST 2003


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