SQL Query Optimization for Mere Mortals!

Join Microsoft MVP Steve Endow as he demonstrates some simple techniques that mere mortals can use to diagnose and optimize SQL Server queries. Topics will include identifying problem queries, redesigning queries, reviewing execution plans, writing sargable queries, utilizing indexes, and using some SQL Server Management Studio query diagnostic features.

Examples will be applicable to all Dynamics databases, so a working knowledge of your own SQL-based system is recommended.