Indexes and Constraints on a Partitioned Table
In a partitioned table, the partition column must be a part of:
- The clustered index key.
- The primary key.
- Unique index and uniqueness constraint keys.
In a partitioned table, the partition column must be a part of:

Interesting little trick to avoid table locks when updating a complete large table in SQL Server 2005 and higher.