Any video courses that teach Execution Plans?

Question

Any video courses that teach Execution Plans?

primitivefuture2006

Old Hand

Points: 389
More actions
February 4, 2019 at 7:08 pm

#370530

Hi,
I am aware that Redgate has a free ebook that explains execution plans. I was wondering if there were video courses (free or paid) that can explain execution plans and code parsing via video training. The Redgate book is great, but some more visualizations and demonstrations would be amazing. Thank you!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

I don't know of a complete course on this. I have several videos on my Youtube channel. I'll probably record more, but I doubt I'll ever do enough videos to equal what the book does. I hope that helps a little.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

jacob.saugmann SSC Enthusiast Points: 187 More actions · Answer 2

Hi

Brent Ozar has a few videoes about the subject https://www.brentozar.com/training/statistics-sql-servers-guessing-game/10-execution-plans-made-10m/

In my opinion the Book written by Grant Fritchey is one of the best ways getting started learning Executionplans, also the book Query tuning & Optimaization by Benjamin Nevarez is great .

Hope the link helps a bit.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

jacob.saugmann - Tuesday, February 5, 2019 10:42 AM
Hi
Brent Ozar has a few videoes about the subject https://www.brentozar.com/training/statistics-sql-servers-guessing-game/10-execution-plans-made-10m/
In my opinion the Book written by Grant Fritchey is one of the best ways getting started learning Execution plans, also the book Query tuning & Optimaization by Benjamin Nevarez is great .
Hope the link helps a bit.

This ^^^
Benjamin Nevarez' book is dry but a must read. Grant's book is excellent too (although I only read the first edition). I did this youtube search which has a few good videos: https://www.youtube.com/results?search_query=sql+server+execution+plan . There are good ones by Adam Machanic, Kendra Little and Brent Ozar. You can also see Grant Frichey's video here.

My Personal favorite videos on this topic are by Benjamin Nevarez. He does not have videos with "Execution Plan" in the title but, in all of his subject matter, he does a really, really deep dive into the optimizer and execution plans.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

MattF SSCrazy Points: 2285 More actions · Answer 4

I suggest getting a free membership to PASS (Professional Association SQL Server) - they do webinars and you can access recordings: http://www.pass.org

MattF

Eric M Russell SSC Guru Points: 125561 More actions · Answer 5

Kendra Little does some good video presentations on execution plan analysis.
https://www.youtube.com/results?search_query=kendra+little+execution+plans

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

primitivefuture2006 Old Hand Points: 389 More actions · Answer 6

Thank you everybody for the suggestions! I think what I will do is study Grant Fritchey's book and seek videos for concepts that I don't understand, including the videos suggested here. I will also try to run queries to further my understanding of how the SQL Server optimizer works. Thanks everyone!