Categories
Performance Tunning

How to do Table Partitioning to an existing source table

In this article we are going to see how to partition a existing table in a database. In my working place I got a request from client to partition an existing table, I have searched in BOL but couldnt find the exact detail how to do it. Ive figured out that and Implemented successfully, Im Just sharing the steps with you so that this might be helpful to you.

Categories
DBA

Systables related to partitioning

Below listed are the systables which can be used to get information regarding partitioned tables, indexes are views.

Categories
DBA

Pros and Cons of Partitioning

This article describe pros and cons of partitioning in SQL Server

Categories
DBA

Data Partitioning

This article takes introduces you to the concept of data partitioning in SQL server 2005. It also gives you an example of how to start from the scratch and also how to partition an already existing table.

Categories
DBA

Creating Partitioned Tables

The following are the steps to create a partitioned table.

1.) Create a partition function

2.) Create a partition scheme

3.) Create a table using the partition scheme.