SQL Server 2005 sliding partition and additional indexes problem

Mar 15, 2008 at 4:50 PM
Edited Mar 15, 2008 at 4:51 PM
SQL Server 2005 allows to create sliding partition mechanism on a partition table using ALTER TABLE SWITCH PARTITION. But this can not be used on a table which has additonal non-partitoned indexes (equivalent of ORACLE global indexes).