nerdiness devours me
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.

Read More

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