This is a place where i share about Technology, Management and Spirituality.
Back again
Get link
Facebook
X
Pinterest
Email
Other Apps
Its been a while i have blogged, as usual the reasons been busy :). I feel i should take some time for blogging. Hopefully i will get to be more regular and start sharing on whatever i learn.
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...
Check out the following WPF/E Articles 1. "WPF/E" (Code Name) Architecture Overview at http://msdn2.microsoft.com/en-gb/library/bb190633.aspx 2. Getting Started with "WPF/E" (Code Name) at http://msdn2.microsoft.com/en-gb/library/bb190632.aspx Cheers!!!
Comments