Hi Steve,
Regarding question 1 … we had a similar-sounding partitioned table, continuously populated, and partitioned by the month. So we rotated through the full set of partitions annually. The partitions got quite large, as many as 1 billion rows ...