Good parallel performance depends on a fairly even distribution of data on a table’s partitions. The two major methods to achieve this distribution are:
Creating a clustered index on a partitioned table. The data should already be in the table.
Using parallel bulk copy, specifying the partitions where the data is to be loaded.
sp_helpartition tablename reports the number of pages on each partition in a table.
