• "Dropping and rebuilding a clustered index on a partition scheme may move data to other drives. " ?

    Really? How can that be? The idea of the partition is to locate data in a particular filegroup based on the data in a particular column, right? And the purpose of using the filegroups is to allow the partitioned data to be on different drives, for performance or organizational reasons, correct? So if the data has not changed, why would it be moved to another drive?

    If this is true, it really damages what I thought I understood about partition schemes... but that is why I come here, to learn these nuances 🙂

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems