sqlrambling.net
Automatic Data Purging With Partition Truncation
Some years ago a wrote an article about automatic data purging with partition switching. Having moved to SQL Server 2016 recently I have encountered the new ability to truncate individual partition…