Partitioning Relational Data – (Part – 3)

This is the third part of the three part article series on partitioning relational data. 

In the first part of this three-part article series on partitioning relation data, I started the article by giving an introduction to partition relational data along with the reasons why you might want to partition relational data. Then I discussed how to partition tables and how to match indexes to match partitioned tables. In the end, I discussed the rules that must be taken into account when partitioning tables and indexes.

In the second part of partitioning relational data article series, I discussed and demonstrated how you can convert existing table to partition table, add, modify, remove or switch partitions, and how you can view data in a specific partition.

Checkout the third and last part of partitioning relational data article series here. In this part, I discussed why one might want to partition multidimensional data, overview of SQL Server partitioning architecture, and guidelines for partitioning relational and multidimensional data.

This article is published on SSWUG.org.

Partitioning Relational Data – (Part – 2)

This is the second part of the three part article series on partitioning relational data. 

In the first part of this three-part article series on partitioning relation data, I gave an introduction to partition relational data along with the reasons why someone might want to partition relational data. Then I discussed how to partition tables and how to match indexes to match partitioned tables. In the end I discussed the rules that must be taken into account when partitioning tables and indexes. 

Checkout the second part of partitioning relational data article series here. In this part I discussed how you can convert existing table to partition table, add, modify, remove or switch partitions, and how you can view data in a specific partition.

This article is published on SSWUG.org.