Partitioning a table can improve performance for several types of processes.
Partitioning allows parallel query processing to access each partition of the table. Each worker process in a partitioned-based scan reads a separate partition.
Partitioning allows you to load a table in parallel with bulk copy.
For more information on parallel bcp, see the Utility Programs manual.
Partitioning allows tou to distribute a table’s I/O over multiple database devices.
Semantic partitioning (range-, hash- and list-partitioned tables) improves response time because the query processor eliminates some partitions.
Partitioning provides multiple insertion points for a heap table.
The tables you choose to partition and the type of partition depend on the performance issues you encounter and the performance goals for the queries on the tables.
See Chapter 10, “Partitioning Tables and Indexes” in the Transact-SQL Users Guide book for more information about, and examples using and creating partitions.