SQL Server 2005 introduced the ability to partition a large relation into smaller logical chunks to improve the administration and management of large tables. It has also been used successfully to improve query processing, especially when it comes to large decision-support applications. Further SQL Serve 2008 has enhanced this feature with partitioned table parallelism (PTP) feature.
Partitioned Table Parallelism