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.
yanivetrogi/PartitionsManagement
Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|