[dba-SQLServer] SQL Server 2005 - Shrinking databases

On 1/22/07, Jim Lawrence <accessd at shaw.ca> wrote:
> Hi John:
>
> I was talking with a fellow from Calgary a while back and their company
> removes all the indexes when manipulating large tables that will change the
> indexes. If there is to be a lot of modifications one script is designed to
> remove the indexes and another one is created to add them back. Sometimes
> the most processing time on a project is waiting for the indexes to rebuild.
>
> Jim

That's been my experience, too. Whenever I've had to load tables with
large amounts of data, I've usually used BCP and scripted the
operation (a simple batch file with isql and bcp commands works well)
to drop any indexes prior to inserting and then rebuild them
afterwards.

Stephen