NFP interview question

Query optimization techniques that you use?

Interview Answer

Anonymous

13 Jul 2017

Execution plans, Profiler, DTA, DMVs, statistics io/time, custom scripts, common sense SARGable predicates and best practice T-SQL evaluation, etc.