For tables that aren't partitioned, consider using a CTAS to write down the info you want to hold inside of a table as opposed to applying DELETE. If a CTAS requires a similar amount of time, It really is Substantially safer to operate since it has nominal transaction logging and might be canceled immediately if required.Microsoft Cost Administrati