Here is a video that I created on Indexing for Performance, some of the techniques that I use when doing performance tuning:
Steve Stedman
Founder/Owner — Stedman Solutions, LLC.
SQL Server DBA Services
Looking to schedule a meeting with me? Here is my availability: https://Stedman.us/schedule