Home Forums SQL Server 2008 SQL Server 2008 - General Automate new partition creation in table partitioning RE: Automate new partition creation in table partitioning
Craig Smith
SSChasing Mays
Points: 600
More actions
July 1, 2015 at 9:33 am
#1809565
Here's what I do:
ALTER PARTITION FUNCTION <function_name>()
SPLIT RANGE (@NewDate)
ALTER PARTITION SCHEME <schema_name>
NEXT USED [PRIMARY]
Prior to that I verify that the partition doesn't already exist, but you may not need to bother.