Skip to content

Automate SQL Server Partition Management Sliding Window

Notifications You must be signed in to change notification settings

yanivetrogi/PartitionsManagement

Repository files navigation

Provides an automation for managing/maintaing a partiton function sliding window using a managment table. Deploy the procedures and functions and then use file insert_partition_management_table.sql as an example to populate the managment table (located under the Helpers folder). Folloing that use the file: partition_management_loop.sql (located under the Helpers folder) to test the code from ssms and then copy paste to sql server agent job.

About

Automate SQL Server Partition Management Sliding Window

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published