Michael J. Swart partitions a rather large table:
Aaron Bertrand wants you to consider using partitioned tables and the sliding window pattern to help archive old data.
That’s a great idea. In fact, I’d like to do that at my own job. I have a truly humungous log table (Terabytes) and its clustered index is already on
CreatedDateso it’s a good candidate for this pattern.
Click through to see how, but also one pain point you’re likely to run into when adding partitioning to existing large tables.