partition-scheme

Adding Partitions to the Lower End of a Left Based Partition Function

Adding Partitions to the Lower End of a Left Based Partition Function

I recently got a table partitioning question from a reader:

We now need to load some historical data into the table for 2013 so I want to alter the function and schema to add monthly partitions for this. But I can’t work out how to do this using SPLIT? Every example and tutorial I’ve looked at shows how to add new partitions onto the end of a range, not split one in the middle.