For tables that are not partitioned, think about using a CTAS to write down the info you wish to keep in the table rather than using DELETE. If a CTAS can take the identical period of time, It is really Significantly safer to operate as it has negligible transaction logging https://andresoppoo.suomiblog.com/the-5-second-trick-for-azure-unused-resources-46179835