Rolling Time-based Partitions

(Glynn) Fairly often I hear customers say that they plan a table that accumulates millions of rows per day, and they want to keep around, say, the last 30 days worth of data. (For the sake of examples, I’m going to make it the last 3 days.) So this is a kind of round-robin table, with rolling additi

Read More - Register for Free Membership