Database Administration & Monitoring
SQL Server 2016: TRUNCATE PARTITIONS with sliding Windows scenarios
08.10.2016 by Microsoft Team
Some time ago, I had to deal with a new partitioning scenario that included sliding windows stuff for mainly archiving purpose. Regarding the customer context, I used some management scripts that include this time dropping oldest partition. We didn’t care about(…)