For tables that are not partitioned, consider using a CTAS to put in writing the info you need to retain in a table as opposed to employing DELETE. If a CTAS will take the same period of time, It can be Considerably safer to run since it has negligible transaction https://azure-cost-optimization08428.tinyblogging.com/the-best-side-of-azure-cost-optimization-74213654