http://www.sqlservercentral.com/blogs/basits-sql-server-tips/2013/02/05/partitioning-relational-data-part-2/

Printed 2014/09/14 08:12PM

Partitioning Relational Data – (Part – 2)

By Basit Aalishan Masood-Al-Farooq, 2013/02/05

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.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.