Table Partitioning

  • Hi,

    Can we have two different range on particular date in Table Partitioning.

    For e.g.

    Installment Date

    < 31/08/2009 -- Less then this date

    01/09/2009 and 31/12/2009 -- 3 months time gap

    01/01/2010 and 30/06/2010 -- Here onwards 6 months time gao

    01/07/2010 and 31/12/2010

    01/01/2011 and 30/06/2011

    01/07/2011 and 31/12/2011

    01/01/2012 and 30/06/2012

    01/07/2012 and 31/12/2012

    Every six month one partition

    Kindly Advise

  • Pinal Dave has a great tutorial on Table Partitioning...

    http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply