Table partitioning in SQL 2008 - Why?
Basically, to split up a huge table into smaller sub tables or partitions


offload data into different files/filegroups (with changes in backup/restore strategy too)
separate "working" from "historic" data (without having 2+ separate tables which complicates queries)
allow compression of older data


We're talking 100s of millions of rows and/or high volumes.

You don't partition for a few million rows.