[dba-SQLServer]Union query disk space

Jim Lawrence (AccessD) accessd at shaw.ca
Mon Mar 17 20:06:44 CST 2003


Just a comment; remove all your keys and FK before importing. Imports fast
then add them back. A similar import/export project, according to a friend,
was reduced from 3 days to two hours...

Jim

-----Original Message-----
From: dba-sqlserver-admin at databaseadvisors.com
[mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Fred
Hooper
Sent: Monday, March 17, 2003 1:57 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Union query disk space


Unfortunately, no. Our best guess at the size is 200Gb. Only in the past
week were we able to reconfigure enough to do a backup -- after 6 weeks.
Unfortunately, the data reads for the BI build from that query take 4
days, so we can't even reconfigure temporarily unless we forego backing
up for that period. Still, if we could exist for six weeks, how about
another 4-5 days? Maybe that's our answer. Thanks Francisco.

Fred

|-----Original Message-----
|From: dba-sqlserver-admin at databaseadvisors.com
|[mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of
|Francisco H Tapia
|Sent: Monday, March 17, 2003 4:25 PM
|To: dba-sqlserver at databaseadvisors.com
|Subject: Re: [dba-SQLServer]Union query disk space
|
|
|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.
|:
|
|
|_______________________________________________
|dba-SQLServer mailing list
|dba-SQLServer at databaseadvisors.com
|http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
|http://www.databaseadvisors.com
|
|

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list