Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Table Partitioning Expand / Collapse
Author
Message
Posted Monday, December 6, 2010 11:10 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:00 AM
Points: 491, Visits: 552
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
Post #1031037
Posted Tuesday, December 7, 2010 12:47 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 1:05 AM
Points: 1,904, Visits: 2,842
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/


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1031070
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse