I am using Table Partitioning in SQL 2008, I created a partitioned function right boundary, a partitioned scheme and a partitioning column (datetime) in a way that I have 12 partitions and 13 filegroups (12 for each month of the year and 1 additional filegroup).
Is there a way to create a script that I can run once a year that creates 12 new partitions on 12 new filegroups and set the boundary for each partition as a new month for a new year? i.e. create 12 new partitions per year
This isn't going to be exactly what you want, but it will certainly get you started:
answered Nov 09, 2009 at 12:26 PM
Matt Whitfield ♦♦