TOP GUIDELINES OF AZURE ORPHANED RESOURCES

For tables that aren't partitioned, think about using a CTAS to write down the data you wish to continue to keep inside a desk rather than making use of DELETE. If a CTAS can take the same amount of time, It really is Substantially safer to operate since it has minimum transaction logging and might be canceled immediately if required.Azure SQL Data