Sorry I was still trying to think through how to do so by partitioning. I definetly can change it to not be a sliding window. I imagine in this case, I (or a program) should create partitions for future date in advance on those tables then? For availability group, I thought the archiving program can read from the reqadable secondary to write to the CSV instead of reading from primary, so for the primary database the archiving program just need to do the delete query (so it kinda helped by not needing to select a bunch of data first?)