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