For tables that are not partitioned, consider using a CTAS to jot down the data you want to retain in a desk instead of applying DELETE. If a CTAS normally takes the same length of time, It can be Substantially safer to run because it has nominal transaction logging and https://azure-cost-optimisation42962.theideasblog.com/30943482/the-fact-about-azure-cost-insight-and-report-that-no-one-is-suggesting