Partitioning
In SQL Server 2005, Microsoft introduced Partitioning, a method that makes large data sets easier to manage by limiting how much data is read during a single query. Partitioned tables can be divided among more than one FileGroup in a database. As you plan a partition scheme, determine the FileGroup or FileGroups you will put the partitions on. Assigning partitions to separate FileGroups ensures you can perform independent backup and restore operations. There are two types of table partitioning:
Analyze your data for access trends. Partitioning a table horizontally means each FileGroup contains the same number of columns, but fewer rows. This is often done for tables containing data accumulated over time, so that a smaller window of time may be searched during a query.
Partitioning a table vertically means each FileGroup contains fewer columns, but the same number of rows. There are two types of vertical partitioning:
This moves redundant columns from a table and stores them in smaller tables linked to it by a primary key relationship.
This segments a table into smaller tables with fewer columns so that joining the nth row from each new table reassembles the row in the original table.
|
Copyright © 2016
|
|