Distributing data evenly across partitions

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:

sp_helpartition tablename reports the number of pages on each partition in a table.