SQL Query Optimization for Mere Mortals! (Recorded Webcast)
Watch this recorded webinar where Microsoft MVP Steve Endow demonstrates some simple techniques that mere mortals can use to diagnose and optimize SQL Server queries. Topics include identifying problem queries, redesigning queries, reviewing execution plans, writing sargable queries, utilizing indexes, and using some SQL Server Management Studio query diagnostic features.
Download the slides here.