Paul White NZ (3/20/2010)
Peter Trast (3/20/2010)
"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 🙂
I suppose it is just possible that the clustered index was not partitioned to begin with. Depends how you read it, I guess 😉
Terrible article. Did I mention that already? 😀
Maybe if the data were not previously PARTITIONED, yes, but an assumption not in the question 😎
The clustered index existed before as stated in the question so if both the clustered index and partition scheme were in place previously, data would not move.... anyone say different, please explain... please! 🙂
And, yes, you said that before but I have found it is best just to participate in the discussion without being terribly critical 🙂 Point out specific errors, yes, but never generalize, as in using terms like "terrible", just hurts feelings. Everyone gets a chance to be incorrect now and then. After all, "it depends" is the number one phrase that I associate with SQL...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems