Disable Index on a Specific Partition

I'm performing incremental loads into a 13 mths partitioned table with
indexes alinged by partition. I'm trying to figure out how to disable the
indexes on a specific partition. I've researched and can't seem to fine an
option with the Alter Index Statement that would drop or disable the indexes
on just one partition(current mnth) and than rebuild the indexes for just
this one partition. Well there is a Rebuild option per partition but there
isn't one that I've come across thus far for Disable.I don't think it's possible to selectively disable or drop indexes on a
specific partition. You might instead consider switching the partition to a
separate maintenance table, drop those indexes, load, rebuild indexes and
then switch the table back in. If the target partition is empty, you don't
need to bother switching out.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Socrates" <Socrates@.discussions.microsoft.com> wrote in message
news:7D46AD52-ED4D-41C2-93DA-23E58CCF5A85@.microsoft.com...
> I'm performing incremental loads into a 13 mths partitioned table with
> indexes alinged by partition. I'm trying to figure out how to disable the
> indexes on a specific partition. I've researched and can't seem to fine an
> option with the Alter Index Statement that would drop or disable the
> indexes
> on just one partition(current mnth) and than rebuild the indexes for just
> this one partition. Well there is a Rebuild option per partition but there
> isn't one that I've come across thus far for Disable.