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.
Fill Factor 101
Did you ever wonder what the term “fill factor” in conjunction with SQL Server means and were eager to understand it better? The following two part article series explains what the fill factor is and how to choose the right fill factor for your database.
MS SQL Indexing Guidelines
If you ever come to struggle with indexing your database objects the most efficient and profound way and suddenly realize you lack some background knowledge (like me), I just found a great four part article series on Database Journal by Gregory A. Larsen:
