2 out of 7 rated this helpful - Rate this topic

Partitioned Tables and Indexes

SQL Server 2005

The data in partitioned tables and indexes is horizontally divided into units that can be spread across more than one filegroup in a database. Partitioning can make large tables and indexes more manageable and scalable.

This section provides the information that is required to understand, design, implement, and work with partitioned tables and indexes.

In This Section

Topic	Description
Understanding Partitioning	Provides an overview of partitioning and how it can be used in the AdventureWorks sample database.
Designing Partitioned Tables and Indexes	Explains the factors to consider when planning a partitioning scenario in your database, and includes examples.
Implementing Partitioned Tables and Indexes	Provides guidelines, rules, and restrictions for creating and modifying partitioned tables and indexes.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD