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.
-
Notifications
You must be signed in to change notification settings - Fork 1
yanivetrogi/PartitionsManagement
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Automate SQL Server Partition Management Sliding Window
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published