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!
@shatabdidey30564 жыл бұрын
Very Nicely Explained . Was eagerly waiting for the other operators like Hash /Sort/Tables spool/Nested Loop/Compute Scalar etc...
@th14934 жыл бұрын
Amazing!!! The comparison visual towards the end was so simple yet powerful! Thanks a lot! :)
@nitindixit0027 жыл бұрын
best video i watched for execution plan operator
@RC-nn1ld6 жыл бұрын
Wow this is by far the best clip explaining this stuff, thanks!
@arnesbeganovic5 жыл бұрын
Exactly! Finally I understand this.
@davidp75714 жыл бұрын
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.
@LinkMassing6 жыл бұрын
I have watched this more times than I can count over the last year. Excellent!
@zzrabin7 жыл бұрын
Thanks for making this wonderful video. So useful to get insight into those operators.
@fadi4984 жыл бұрын
Excellent video! the best I have watched so far. Thanks a lot.
@mikemeat4 жыл бұрын
Really great and good fun to watch. Thank you!
@susanthabathige58605 жыл бұрын
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.
@trucid28 жыл бұрын
Great stuff. Can't wait for part 2!
@shatabdidey30564 жыл бұрын
I liked the way he presented...straight to the point...Wondering why he didnot introduce himslef..
@TonyTigerTonyTiger22 күн бұрын
If I am not mistaken, you description of scans vs seeks is not consistent with what Brent Ozar himself says about them.
@khawarahmed74925 жыл бұрын
If he introduced himself as a stand-up comic, I wouldn't mind at all.
@unlimitedpowerrecords7 жыл бұрын
Very well done, easy to listen to and follow.
@user-xp5sk8ts3q2 жыл бұрын
Thanks so much for the great video!
@vijay6face Жыл бұрын
Amazing very useful ❤️
@gideaomartins9096 Жыл бұрын
That's a class 🔥
@BrentOzarUnlimited Жыл бұрын
Glad you enjoyed it!
@govansquared4759 Жыл бұрын
sought on or seeked on, that is the question.. not surprised doug got head hunted after this
@BrentOzarUnlimited Жыл бұрын
Yep, he's really sharp!
@tsilb4 жыл бұрын
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!
@BrentOzarUnlimited4 жыл бұрын
Kevin - unfortunately, Doug Lane left the company just after this video was filmed. We gave it away for the public anyway - hope you enjoy it.
@narcissistectomy51345 жыл бұрын
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?
@BrentOzarUnlimited5 жыл бұрын
Sorry, we never built the second video. We stopped the project, but we wanted to upload this one for you so you could at least enjoy the completed one. Thanks!
@narcissistectomy51345 жыл бұрын
Brent Ozar Unlimited NOOOOooooo! can you point me to a comprehensive source of all the execution plan steps explained? I’m diving into the deep depths of database operations, and am looking for good info
@BrentOzarUnlimited5 жыл бұрын
@@narcissistectomy5134 no, sorry.
@atul1219845 жыл бұрын
Superb Stuff !!!
@Eskinidirisahero Жыл бұрын
thank you sir
@BrentOzarUnlimited Жыл бұрын
Most welcome
@PhuNguyen-bi7pi5 жыл бұрын
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?
@TheBrentOzar5 жыл бұрын
There won't be one - Doug moved on to another company.
@nvprophecy2 жыл бұрын
great video!
@BrentOzarUnlimited2 жыл бұрын
Thanks!
@deva84967 жыл бұрын
I did not understand what you saying about "heaps don't behave well when it comes to the deleted rows" please explain.
@LanceEnglandSQL7 жыл бұрын
You need to put a table lock hint on the heap table when deleting rows or the empty data pages aren't returned to SQL Server. It's the storage equivalent of a memory leak.
@odivm8 жыл бұрын
Yep, me too. Excellent video. Thanks you for doing it.
@ghauan6 жыл бұрын
Great video
@donatobarone34748 жыл бұрын
Yep, great video! When will the part 2 be released? Thanks
@TheBrentOzar8 жыл бұрын
Hi! Unfortunately, there won't be a part 2 to this. Doug's moved on from the company. Thanks though!
@BrusyurSoksow8 жыл бұрын
Thats a shame! no one else on the Ozar team care to have a crack? This is the bees knees.
@purnachandrak21483 жыл бұрын
Best one
@khawarahmed74925 жыл бұрын
Brent is full of sass.
@nickj91378 жыл бұрын
thank you!
@apikey31976 жыл бұрын
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
@Sezayiyuksektepe5 жыл бұрын
Thank's baby.
@kayodejohnson80082 жыл бұрын
nice tutorial
@MrRapperb4 жыл бұрын
Wait!! is he Brent Ozar?
@Mitu9186 жыл бұрын
Where is the part 2?
@BrentOzarUnlimited5 жыл бұрын
That's it for this series - you can find other courses at www.BrentOzar.com.
@kaustavganguly44545 жыл бұрын
Any link for the Part two video??
@TheBrentOzar5 жыл бұрын
That's it for this series - you can find other courses at www.BrentOzar.com.