For fastest performance, use fast bulk-copy to copy data into partitioned tables. For each bulk-copy session, specify the partition on which the data should reside.
If your input file is already in sorted order, you can bulk-copy data into partitions in order, and avoid the sorting step while creating clustered indexes.
See Chapter 10, “Partitioning Tables and Indexes,” in the Transact-SQL Users Guide for step-by-step procedures.
