question

skpani avatar image
skpani asked

LEFT and RIGHT in PARTITION FUNCTION

What is the significant difference of using LEFT and RIGHT in the definition of a PARTITION FUNCTION .Where to use Left and where to use Right ?
table partition
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
raadee avatar image
raadee answered
Kimberly Tripp wrote an article about this topic with a nice explanation and why Right is the recommended choice. [Clarifying LEFT and RIGHT in the defintion of a PARTITION FUNCTION][1] Also have a look at examples A and B on technet for an quick way to understand. [CREATE PARTITION FUNCTION][2] [1]: http://www.sqlskills.com/blogs/kimberly/clarifying-left-and-right-in-the-defintion-of-a-partition-function-in-sql-server-2005/ [2]: http://technet.microsoft.com/en-us/library/ms187802.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.