For tables that are not partitioned, think about using a CTAS to jot down the data you need to retain inside a table in lieu of working with DELETE. If a CTAS takes a similar amount of time, It is much safer to run because it has small transaction logging https://azurecostinsightandreport74073.worldblogged.com/36423928/azure-orphaned-resources-secrets