I have a table that is used for staging. It has a unique clustered index on it that has the same partitioning as the table. I want to know if there is a way for me to add a non-clustered, non-partitioned index to the table and still
be able to do the partition swapping. Are there any work arounds? I have found that because the indexes are 'not-aligned' the swapping fails to insert into the table with the multiple indexes.
View Complete Post