Partitioning Tables in SQL SERVER

Partitioning is helpful for managing and accessing smaller chunks of data very efficiently and at a faster pace without compromising on data integrity.

SQL Server supports Range Partitions. This means that the partitioning is based on data ranges.

Comments

Post a Comment

Popular posts from this blog

Building a Simple Windows Phone 7 application

Image
In this article, we will build a simple windows phone application. We have seen in the earlier blog post on the installation of windows phone SDK. We will see how to create a simple application which will save the contacts on a windows phone. Let’s begin by choosing the Windows Phone Application project as shown below By default the “MainPage.xaml” file is created, we will modify the application title and page title as in the StackPanel as shown below < StackPanel x : Name ="TitlePanel" Grid.Row ="0" Margin ="12,17,0,28">       < TextBlock x : Name ="ApplicationTitle" Text ="Contact App" Style ="{ StaticResource PhoneTextNormalStyle }"/>       < TextBlock x : Name ="PageTitle" Text ="My Contacts" Margin ="9,-7,0,0" Style ="{ StaticResource PhoneTextTitle1Style }"/> StackPanel > We will add the application icons add, delete ...
Read more

Partition Function in SQL Server

The partition function is created for setting the range partitions. The ranges can be set for a lower or upper threshold. This is the first step in creating partitions The syntax is as follows CREATE PARTITION FUNCTION ( ) AS RANGE LEFT/RIGHT FOR VALUES ( , ,…) LEFT : This specifies the maximum value of the first partition RIGHT : This specifies the minimum value of the second partition. The below examples shows creating a partitions as follows Partition 1 : column1 Partition 2 : column1 > 1 and column1 Partition 3 : column1 > 100 and column1 Partition 4 : column1 > 1000 CREATE PARTITION FUNCTION EmployeePartitionLeft (int) AS RANGE LEFT FOR VALUES (1, 100, 1000) The below examples shows creating a partitions as follows Partition 1 : column1 Partition 2 : column1 >= 1 and column1 Partition 3 : column1 >= 100 and column1 Partition 4 : column1 >= 1000 CREATE PARTITION FUNCTION EmployeePartitionRight (int) AS RANGE RIGHT FOR VALU...
Read more