I'm in a situation where I have taken over a very large db that is primarily a single table that is partitioned. Since it hasn't been partitioned for a while, I need to re-start the partitioning, but it is a 24/7 business and it can't be out for a few hours while SPLITing the older partitions.
If I was to create the new partition for the end of this month, then go back and SPLIT the previous partitions - is there a problem with doing them out of order, other than the partition id being in the wrong order?
Is there any performance or maintenance differences if the order of the partition id is not in sequence with the partition key order?