|
|
Posted by Greg D. Moore \(Strider\) on 09/08/05 04:07
"oshanahan" <UseLinkToEmail@dbForumz.com> wrote in message
news:4_877392_d587ff258b12b87ecad29412bef18c20@dbforumz.com...
> Does anyone have ideas on the best way to move large amounts of data
> between tables? I am doing several simple insert/select statements
> from a staging table to several holding tables, but because of the
> volume it is taking an extraordinary amount of time. I considered
> using cursors but have read that may not be the best thing for this
> situation. Any thoughts?
>
For SQL Server, DTS, bcp or bulkcopy.
Do NOT use cursors.
And if you can, drop indexes first and build them later.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/General-Discussions-Inserting-large-amounts-data-ftopict254055.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=877392
Navigation:
[Reply to this message]
|