disabling indexes on dts

#1

Hello there

I have huge database that gets at least 10,000,000 on dts action. In the
recived table there are some indexes, constraints, and primary key
clustereds. Do get better performance i: 1. delete all indexes, constraints
and primary key
2. import data
3. bring back the indexes

Is there a way to disable the indexes wile using dts instead of drop and
recreate it?

#2

"Roy Goldhammer" wrote:

Quote:

I have huge database that gets at least 10,000,000 on dts action. In the
recived table there are some indexes, constraints, and primary key
clustereds. Do get better performance i: 1. delete all indexes,
constraints and primary key
2. import data
3. bring back the indexes

Is there a way to disable the indexes wile using dts instead of drop and
recreate it?

You can disable indexes only if you are using SQL Server 2005.

Francesco Anti

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

disabling indexes on dts

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

disabling indexes on dts - 03-22-2006 , 05:22 AM

Re: disabling indexes on dts - 03-22-2006 , 10:43 AM