Need Help With Partitioning.
I have a Table
Create Table OrdersFromSystemsFeedTable
Need to remove data which is 3 months old, Huh!! Dodle, easy to do this, Catch !! how to make sure that the data which is not processed which is older than 3 months is not archived via Paritioning.
Is there a way this can be done or I am barking the wrong tree.
Feed Table is huge 30M Records and 5M Each month growth Stats.