I have the privilege of managing a large partitioned
OLAP table. While reviewing this table I noticed one of the indexes is not aligned with the partitioning scheme. Since the author is not available and carefully crafted Google searches have not returned any useful results I am not sure if this was intentional or accidental.
Is there any reason not to partition align an index on SQL Server 2008?