Understanding Partitioning

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

Understanding Partitioning

The topics in this section provide the information to help you understand the concepts of partitioned tables and indexes and the reasons for implementing partitioning, and an overview of how partitioned tables and indexes are implemented in the AdventureWorks sample database.

In This Section

Topic	Description
Partitioned Table and Index Concepts	Explains partitioned tables and indexes, and the benefits of partitioning.
Partitioning in the AdventureWorks Sample Database	Explains the partitioning scripts that can be run against the AdventureWorks sample database to implement a partitioning design, and the benefits of this design in a real-world scenario.