Michael Bourgon explains what the
WAIT_AT_LOW_PRIORITY option does with table partitioning and that it is available in Standard Edition:
But how about WAIT_AT_LOW_PRIORITY? That was introduced in 2014 to make table partitioning deal better with That-Dude-From-Accounting-Who-Kicks-Off-A-Massive-Query-On-Friday-at-5pm, which causes partitioning to hang on Saturday when you’re trying to add and remove partitions.
Read on for a demo.