Initially the lecture was not impressive to me....looked like so regular things what he is discussing....many facts people might know....still I watched patiently till the end....where I got a clue to one of my production issue...a query was running much slow...when the lecture was on clustered index will do much better sometimes...and about creating indexes on text field...I thought of giving it a try...and tried creating an index ...which might go for clustered index seek for that text filed....it worked! The query which was running for nearly 9 sec to 17-18 seconds....came down to 3 to 8 seconds....mostly around 2-5 seconds which was our SLA for this application! Thanks for taking time to post this video! Much Appreciated!

Very Nicely Explained . Was eagerly waiting for the other operators like Hash /Sort/Tables spool/Nested Loop/Compute Scalar etc...

Amazing!!! The comparison visual towards the end was so simple yet powerful! Thanks a lot! :)

best video i watched for execution plan operator

Wow this is by far the best clip explaining this stuff, thanks!

This is a fantastic tutorial and would have made a great series. Sad to read that Doug moved on and that there will be no second part. Thanks for sharing this part nonetheless.

I have watched this more times than I can count over the last year. Excellent!

Thanks for making this wonderful video. So useful to get insight into those operators.

Excellent video! the best I have watched so far. Thanks a lot.

Really great and good fun to watch. Thank you!

Clustered Index scan or index scan does not necessarily read entire rows of a table, it could be a range scan as well. If you hover the mouse over the operator you will see the description as (Scanning a clustered index, entirely or only a range). Here it pays much more attention to the cost of the operator but it is meaningless to the end user as it uses by the query optimizer to create the plan.

Great stuff. Can't wait for part 2!

I liked the way he presented...straight to the point...Wondering why he didnot introduce himslef..

If I am not mistaken, you description of scans vs seeks is not consistent with what Brent Ozar himself says about them.

If he introduced himself as a stand-up comic, I wouldn't mind at all.

Very well done, easy to listen to and follow.

Thanks so much for the great video!

Amazing very useful ❤️

That's a class 🔥

sought on or seeked on, that is the question.. not surprised doug got head hunted after this

When you end a video with "Coming up...", could you maybe please link to the next video in the description? Thanks, and keep being awesome!

At the end of the video, you indicate there is another video with more operators like key lookup and join, but I do not see it in your video library. I'm quite sure you've got that content somewhere, I'm just not seeing it. Could you please point me in the right direction?

Superb Stuff !!!

thank you sir

Hey, thanks for the videos. The best SQL lesson I've learned in my life for sure. Thanks. Where's the part 2? Anyone can drop me a link?

great video!

I did not understand what you saying about "heaps don't behave well when it comes to the deleted rows" please explain.

Yep, me too. Excellent video. Thanks you for doing it.

Great video

Yep, great video! When will the part 2 be released? Thanks

Best one

Brent is full of sass.

thank you!

The part where it got dark to show the table diagram freaked me out because I was watching the video at full screen. I thought my monitor was dying. :o

Thank's baby.

nice tutorial

Wait!! is he Brent Ozar?

Where is the part 2?

Any link for the Part two video??

32:20

Ok

This video is plain wrong.