InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:54:50 GMT20http://www.sqlservercentral.com/Forums/Topic1031037-146-1.aspxPinal Dave has a great tutorial on Table Partitioning...[url]http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/[/url]Tue, 07 Dec 2010 00:47:17 GMTHenrico Bekkerhttp://www.sqlservercentral.com/Forums/Topic1031037-146-1.aspxHi,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 gap01/01/2010 and 30/06/2010 -- Here onwards 6 months time gao01/07/2010 and 31/12/201001/01/2011 and 30/06/201101/07/2011 and 31/12/201101/01/2012 and 30/06/201201/07/2012 and 31/12/2012Every six month one partitionKindly AdviseMon, 06 Dec 2010 23:10:20 GMTchetanr.jain