Need consultancy for dynamic partitioning in MS Sql Server DB
Budget: ₹600 – ₹1,500 INR
We have a database with a table having large number of records we need to create horizontal partitioning. script that can be run as scheduled job to create two partitioning in advance to accommodate future records on the basis of upcoming months suppose we are in November 2022 and we already have another partition for dec 2022 on secondary file group and the primary file group is set for future values which are greater than dec 2022, objective is to create new partition for Jan 2023 and in advance and set this primary for value more than Jan 2023.