EXAMINE THIS REPORT ON AZURE COST ANALYSIS

For tables that aren't partitioned, think about using a CTAS to put in writing the information you would like to preserve in the desk in lieu of utilizing DELETE. If a CTAS can take exactly the same amount of time, It really is Substantially safer to run since it has nominal transaction logging and will be canceled quickly if necessary.Tradeoff: Co