To create a new empty partition for the new month’s data, we can use the SPLIT RANGE clause of the ALTER PARTITION FUNCTION statement. To remove unused empty partitions we can use the MERGE RANGE ...
In a previous blog entry I talked about the Sliding Window partitioning scenario. I even tried to involve Gwyneth Paltrow in a SQL Server Blog which is no mean feat. (When you teach classes over the ...