A table containing some old data 2000-2009 now contains 50mill rows
I would partition this table into year partitions.
Is it possible to remove a partition (every partition with data older than 2 years).
And then when needed add the partition again ?
So the partition should be detach and attachable from a script/batch.
Or is this not possible ?