[dba-SQLServer] Export wizard hangs

BCP is very fast way of getting SQL Server data out and into a text file, check it out in BOL or google it.  Also very easy to use.

Nancy Lytle 
N_Lytle at terpalum.umd.edu









 EMAILING FOR THE GREATER GOOD
Join me
 
> Date: Wed, 23 Sep 2009 11:09:45 -0400
> From: jwcolby at colbyconsulting.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Export wizard hangs
> 
> Behind the scenes I have no idea. It is the wizard that is running.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Nancy Lytle wrote:
> > Are you doing a BCP out?
> > 
> > Nancy Lytle 
> > N_Lytle at terpalum.umd.edu
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > EMAILING FOR THE GREATER GOOD
> > Join me
> > 
> >> Date: Wed, 23 Sep 2009 10:41:37 -0400
> >> From: jwcolby at colbyconsulting.com
> >> To: dba-sqlserver at databaseadvisors.com
> >> Subject: [dba-SQLServer] Export wizard hangs
> >>
> >> I am trying to export 50 million names / addresses to a CSV file. I did so once using a simple 
> >> query that pulls from a single table. I realized I needed to join on the zip from another table (in 
> >> a zip code database) which filters down which zip codes and states I use. this is normal stuff, I 
> >> do it all the time.
> >>
> >> I have a query which I built to do this. I can do a count (PKID) on this table and get results back 
> >> in just a few seconds. However the export wizard exports about 50K records and hangs "performing 
> >> operation", with the little circle widget a circlin'.
> >>
> >> Indexes applied on all relevant join fields etc.
> >>
> >> It has something to do with the join to the ZipCodeWorld out in the other database. Take that out 
> >> and the thing flies. 50K records / second perhaps. Put the zip code view back in to the source 
> >> query and the thing slows to a crawl. It looks like it is doing 10K chunks every 30 seconds or so.
> >>
> >> I use this zip code world view all of the time! Joined to this and other tables. And the weird 
> >> thing is that I can view the data and it opens instantly and starts displaying data like a mad man. 
> >> Count the PK from the view and it counts in just a few seconds. But the export wizard is having 
> >> problems with the view, but only when that zipcode view is joined in.
> >>
> >> Any ideas why?
> >>
> >> -- 
> >> John W. Colby
> >> www.ColbyConsulting.com
> >> _______________________________________________
> >> 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
> > 
> > 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>