For tables that aren't partitioned, consider using a CTAS to write down the info you would like to maintain within a desk instead of utilizing DELETE. If a CTAS can take exactly the same period of time, it's Significantly safer to operate as it has minimal transaction logging and may be canceled promptly if needed.The catch is the fact Microsoft ca