[Video] SQL Performance Troubles – Execution Plans – Live 2

When I presented the very first YouTube Live, I was extremely nervous about what if something goes wrong and it did. My Microphone failed. In the second episode, I had made sure that my Microphone works properly. However, this time, I faced another issue that my Camera stopped working. Fortunately, I had backup. Let us see what today’s video SQL Performance Troubles – Execution Plans – Live 2.

Discussion Points – Live 2

• • 0:00 Let’s start
  • 1:35 Demo: Real-world scenario
  • 9:30 Don’t trust Execution Plan
  • 11:20 Camera Froze
  • 13:00 Camera UnFroze
  • 15:00 Actual vs Estimated Execution Plan
  • 20:00 Live Execution Plan
  • 22:30 Find table in SSMS
  • 23:40 Attaching SQL Plan
  • 25:10 Location of Free Scripts
  • 25:33 Final Puzzle
  • 28:00 Final Final Puzzle
  • 29:15 Thank you

In this video, I discuss execution plans and real-world scenarios. We also discuss the estimated execution plan and actual execution plan. Right at the end of the session, we also discussed an interesting puzzle. Please leave a comment and let me know if you enjoyed the session (Live 2) or not. I will be happy to do more based on your feedback.

Many such tricks, I often discuss during Comprehensive Database Performance Health Check.

If you liked this blog, please do not forget to subscribe to my YouTube Channel – SQL in Sixty Seconds.

Here are my few recent videos and I would like to know what is your feedback about them.

• Queries Using Specific Index – SQL in Sixty Seconds #180
• Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179
• One Scan for 3 Count Sum – SQL in Sixty Seconds #178
• SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177
• COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176

Reference: Pinal Dave (http://blog.SQLAuthority.com)