THE ULTIMATE GUIDE TO AZURE ORPHANED RESOURCES

For tables that are not partitioned, consider using a CTAS to write the data you need to maintain inside a table rather than working with DELETE. If a CTAS takes the same length of time, It can be Significantly safer to run because it has minimal transaction logging and may be canceled promptly if necessary.All capabilities in your neighborhood job