Is there anyway to drop or disable an index at the partition level in SQL 2005 ?
There is a way to rebuild at the partition level.
i.e.: alter index ALL on dbo.LP_CQ rebuild partition = 229 ;
I want to:
1. Drop or disable index(es) at the partition level (range partition by week).
2. Load data which can include lots of late arriving facts.
3. Rebuild at Partition level.
I can disable all the partitions but I only need to disable a few. It's a big fact table.
Thx