Here is a few links to articles, white papers, and best practices on partitioning on Microsoft SQL Server. I have these at the end of my slide deck on layered partitioning, which uses a combination of partitioned tables and a partitioned view, and thought that I would put them up here as well.
- Partitioned Tables and Indexes in SQL Server 2005
- Partitioned Table and Index Strategies Using SQL Server 2008
- Partitioned Table and Index Strategies Using SQL Server 2008 white paper
- SQL Server Best Practice Article about loading bulk data
- Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server
- Introduction to Partitioned Tables
- Partition Elimination in SQL Server 2005
- Clarifying LEFT and RIGHT in the definition of a PARTITION FUNCTION in SQL Server 2005
- Index Defrag Best Practices – Fragmentation, Deletes and the “Sliding Window” Scenario and it’s the LAST one!
- SQL Server Table Partitioning: Resources
- Partitioning on SQLServerPedia
