Nigel Rivett wrote an awesome blog on partitioned tables in SQL Server 2005 that provides a lot of useful information and applicable examples. If you are thinking of partitioning your tables, start here.
Information Covered
- Creating a Partitioned Table
- Adding and Removing Partitions
- Switching a Populated Partition
- Identities in a Partitioned Table
- Clustered Indexes
- Unique Indexes
- Non-Unique Indexes
- Computed Partitioned Functions
- Partitioning on Multiple Columns
- Sliding Date Range Partitions
posted on Tuesday, April 17, 2007 2:13 PM