Distributing and Partitioning Data in SQL Server 2008

A Partition Function defines the set of boundary points for which data will be partitioned, otherwise a partition scheme provide an alternate definition for storage. You define a partition scheme to encompass one or more file groups.
The final step in creating a partitioned table or index on a partition scheme through a partitioning column. Creating partitioned table, index, or indexed view is very similar to creating a non partitioned table, index, or indexed view. Creating partitioned index, similar to creating a partitioned table, by specifying a partition scheme.

Managing Partitions
Split operator introduces a new boundary point into a partition function.
Merge eliminates a boundary point from a partition function.

INFO Careful using SPLIT and MERGE

The purpose of partitioning is to SPLIT a table and its associated indexes into multiple storage structures.

Switch the basic idea is that SWITCH allows you to exchange partitions between tables in a perfectly scalable manner with no locking, blocking, or deadlocking.
By Switch the source or target table cannot participate in Replication and cannot have FILESTREAM.

© 2011 Atdhe Buja
All rights reserved.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: