Techniques for Data Aging
See the question and my original answer on StackOverflowThis whitepaper: Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server has a chapter on Data Aging with a sliding window implementation.
This whitepaper: Strategies for Partitioning Relational Data Warehouses in Microsoft SQL Server has a chapter on Data Aging with a sliding window implementation.