An Azure SQL Database table named FactOrderHistory is partitioned monthly by using a RANGE LEFT partition function. The oldest month is in partition 1, and an empty high-end partition already exists. You need to remove the oldest month and create a new future month while avoiding data movement. Arrange the necessary steps in the correct order.
Mark the partition scheme NEXT USED [PRIMARY] and run SPLIT RANGE for the new upper boundary
Run ALTER TABLE ... SWITCH PARTITION to move the oldest partition to the staging table
Create a staging table with a matching schema, aligned index, and check constraint for the oldest month
Run TRUNCATE TABLE on FactOrderHistory before changing the partition function
Run MERGE RANGE on the lowest boundary that was switched out