EVERYTHING ABOUT AZURE PERFORMANCE TUNING

For tables that are not partitioned, think about using a CTAS to write down the data you want to hold inside of a table rather then making use of DELETE. If a CTAS can take exactly the same period of time, It is really Significantly safer to operate as it has minimum transaction logging and may be canceled promptly if needed.Requests and boundaries