Data Warehousing: Horizontally Partitioning the Fact Table

A horizontally partitioned fact table’s rows are divided into discreet, non-overlapping sections. These sections are defined by a range of values in the FOR VALUES clause. To horizontally partition a fact table you need to create a partition function, a partition scheme, and a partitioned table.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=98007