The Best Solution for SQL Server Partitioning Sliding Window

You already know what is Data Partitioning in SQL Server. It’s nothing new. But turns out that there is a shortage of solutions available online for easily managing partitioned tables.

Sure, there are a bunch of blog posts and guides and webinars about WHAT is partitioning in SQL Server, and WHAT is a “Sliding Window… And sure, there is even enough information out there to help you construct your own partition sliding window maintenance for your specific partition functions and schemas and tables.

But if you know me, you should already know that my idea of a “best solution”… is a GENERIC solution. One that could be easily reused for multiple different use cases. One that requires minimum customizations and coding to work for as many different scenarios as possible.

Unfortunately, I wasn’t able to find such an existing solution anywhere.

That is why I created The Best Solution for implementing SQL Server Partitioning Sliding Window. Namely – a GENERIC one.

(yeah I know it’s a rather pretentious and self-serving title… But I had to catch your attention somehow, didn’t I?)

Anyways, the solution consists of two stored procedures, both available in our GitHub repository:

There are also a few more useful scripts within the same folder:

For more details, please read the full post published at the official Madeira Data Solutions site.

There’s also a README file with instructions available within the same GitHub folder.

Have fun!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.