Creating Partion Function

• ramana3327

  SSCoach

  Points: 19722

  More actions

  August 27, 2014 at 8:37 am

  #292627

  Hi All,

  We are using Sql 2008R2. I have a existing table with create date column.

  That table has 6 years data. I want to do partition that table like 1 partition to have 2014 records and 2nd partition to have 2013 records and 3rd partition to have remaining all the years data.

  How to create partition function to this table. I am thinking that we need to take like this

  create partion Function pfInsertedDateRange (DateTime)

  AS

  Range Right for values ('2012/1/1', '2013/1/1', '2014/1/1')

• WorkasDBA

  SSCommitted

  Points: 1684

  More actions

  August 27, 2014 at 12:12 pm

  #1741439

  Its good design to keep every year on its own partition, so that you slide/merge and purge data year by year. With three years in one Partition, what will be your split plan?. This article is a very good read http://www.sqlskills.com/blogs/kimberly/clarifying-left-and-right-in-the-defintion-of-a-partition-function-in-sql-server-2005/