For tables that are not partitioned, consider using a CTAS to jot down the data you need to retain in a table in lieu of using DELETE. If a CTAS normally takes a similar amount of time, It truly is Substantially safer to run since it has nominal transaction logging and might be canceled quickly if required.We must always do not forget that previous… Read More