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
The Panel - Code and Examples
Code examples and applications for WPF and Windows Live applications. The Panel is the place to collect showcases of new user experiences and provide insights on how they were implemented. WPF applications and Windows Live gadgets are featured.