Platform Modernization Alliance
Sign In

Platform Modernization Alliance

:

SolidQ

:

Research Papers: SolidQ - Partitioned Table and Index Strategies Using SQL Server 2008

Open

Body

​SQL Server Technical Article


Writer: Ron Talmage, Solid Quality Mentors
Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft
Greg Low, Herbert Albert - Solid Quality Mentors

Published
: March 2009
Applies to: SQL Server 2008

Summary
: Table partitioning can make very large tables and indexes easier to manage, and improve the performance of appropriately filtered queries. This paper contains a thorough coverage of strategies for partitioning tables, including the required partition functions and partition schemes. The benefits of partition elimination, partition parallelism, and index partition maintenance are also explored. These strategies are applied to various partitioning scenarios such as the sliding window scenario, data archiving, and partition consolidation and movement.

Expires

 

Attachments

PartTableAndIndexStrat.docx    
Content Type: Research Papers
Created at 11/23/2015 2:00 PM by v-shaas
Last modified at 11/23/2015 2:00 PM by v-shaas