Slow SQL Inserts

We had a team member that was partitioning large tables based a CreateDate column. The goal was to improve performance by only keeping the last 7 months of data for some of the larger tables on Azure SQL Server Hyperscale. The query that was run usua...