For tables that aren't partitioned, think about using a CTAS to write the data you wish to continue to keep in a table instead of employing DELETE. If a CTAS can take the same amount of time, It really is Substantially safer to operate as it has minimal transaction logging https://azureorphanedresources19629.dbblog.net/3815189/the-fact-about-azure-cost-insight-and-report-that-no-one-is-suggesting