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 < Function Name > (< DataType >) AS RANGE LEFT/RIGHT FOR VALUES (< value1 >,< value2 >,…)

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 <= 1
Partition 2 : column1 > 1 and column1 <= 100
Partition 3 : column1 > 100 and column1 <= 1000
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 < 1
Partition 2 : column1 >= 1 and column1 < 100
Partition 3 : column1 >= 100 and column1 < 1000
Partition 4 : column1 >= 1000

CREATE PARTITION FUNCTION EmployeePartitionRight (int) AS RANGE RIGHT FOR VALUES (1, 100, 1000)


Comments

Post a Comment

Popular posts from this blog

“Unable to retrieve the metadata for …” Error while using ASP.NET MVC 3

While adding a controller in ASP.NET MVC 3 application, you might get a error “Unable to retrieve the metadata for …”. This error is due to the incorrect connection string name or the connection string in the web.config. I had encountered the same error and the issue was that the name of my DBContext was different from that of the web.config connection string name. When I made it same it was able to create the controller.
Read more

Building application using ASP.NET MVC and MongoDB

Image
This article talks about building a simple application using ASP.NET MVC and MongoDB. From my earlier blog post, the installation steps for Mongo DB were explained. For building application using MongoDB and .NET, we need the 10gen C# Driver. This can be downloaded from http://github.com/mongodb/mongo-csharp-driver/downloads Let’s began creating a simple ASP.NET MVC 3 application. We will be creating a simple application which will save the contact details and view the same. The contact model is as show below     public class Contact     {         [ Required ]         [ Display (Name = "Contact ID" )]         public int ContactID { get ; set ; }              [ Required ]         [ Display (Name = "Name" )]    ...
Read more

Visual Studio 2013 and .NET 4.5.1

Microsoft released VS 2013 and .NET 4.5.1 . Some of the key highlights are as below Innovative Features for Greater Developer Productivity Support for Windows 8.1 App Development Web Development Advancements Create Modern Business Apps for Office 365 Debugging and optimization Improvements Expanded ALM Capabilities To read about them , please check out http://www.microsoft.com/visualstudio/eng/visual-studio-2013#story-2013
Read more