SQL Server 2008 has removed the bottleneck of  single-thread per partition over partitioned tables, which was found in SQL Server 2005.  The previous bottleneck  can cause performance problems under certain circumstances: On systems with many CPUs, if the table schema has less partitions than there are CPUs, then not all the CPUs will be used to [...]