For tables that aren't partitioned, consider using a CTAS to write the information you should keep inside a table in lieu of using DELETE. If a CTAS will take precisely the same length of time, it's A lot safer to run because it has small transaction logging and will be https://martinllllk.post-blogs.com/51958027/getting-my-azure-cost-optimization-to-work