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.

Advertisements

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in Personal Blogs, SQL Server 2008 and tagged , , , , , . Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s