I nearly always use execution plans as the starting point for SQL query performance troubleshooting. In this multi-part series, I plan to review the basics of execution plans and how you can use them to improve the performance of your own queries.
Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/DataWithBert?sub_confirmation=1
Check out the full post for example queries and screenshots:
https://bertwagner.com/2019/07/23/introduction-to-sql-server-execution-plans/
Follow me on Twitter:
https://twitter.com/bertwagner