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.
Pretty T-SQL script returning a granular level of detail when looking at disk space usage of your databases. Shows disk usage of each table broken out by partition and filegroup. Could come in handy!
