For tables that are not partitioned, consider using a CTAS to put in writing the info you want to preserve in a very desk instead of making use of DELETE. If a CTAS can take the same length of time, it's Considerably safer to operate as it has minimum transaction https://marioyyxxw.goabroadblog.com/29865329/the-5-second-trick-for-azure-cost-optimization