SQL Performance Tuning

Analyse query execution plan (IO/ time) Avoid lazy spooling (temporary memory for computation) caused by duplicate aggregation Ignore lazy spooling caused by recursive queries Unnecessary query minimization using cross apply, outer apply..... Par...