When SQL Server performs data sorting for I/O operations, it sorts the data first by partition. SQL Server accesses one drive at a time, and this might reduce performance. To improve data sorting performance, stripe the data files of your partitions across more than one disk by setting up a RAID. In this way, although SQL Server still sorts data by partition, it can access all the drives of each partition at the same time.http://msdn.microsoft.com/en-us/library/ms190787.aspx
Although you are not required to keep each table or index partition (or subpartition) in a separate tablespace, it is to your advantage to do so. Storing partitions in separate tablespaces enables you to:* Reduce the possibility of data corruption in multiple partitions
rp0428 wrote:Go back and look at Mark's post, and we can all smile more.
Mark, we're going to put you in a striped prison outfit if you keep on talking about stripping!
You may want to mind your "p's and q's" (especially your "p's).
Using two "p's" instead of one gives that sentence an entirely different meaning. ;)