10 Query Tuning Techniques Every SQL Programmer Should Know

Presenters:
Kevin Kline
Aaron Bertrand

[@adityaroy452]

Great, great watch. I won't say one would materialize on everything told here, but if you are confused on whether you should invest your time in this ~95 mins video, I would definitely recommend it!

[@kenpat5]

Great Content! Learned quite a bit...

[@anand94087]

great presentation, very helpful. Thanks

[@PrakashPraaku]

Thanks for this great video. Really helpful.

[@hameed9104]

Excellent presentation ,Very Helpful

[@yyyyyc]

Great Lecture !!

[@adaylateacoinshort]

Thanks for this. Very useful.

[@user-ou9vw6oy6b]

سقس

[@mendalin123999]

very nicely explained. do you have something for oracle.. please share

[@TheAguydude]

@1:16:22 - SQL 2016 adds STRING_SPLIT. Probably table-valued parameters are still better, though.

[@temesgenneberu2054]

it is realy nice

[@SinskariBoi3366three]

Advancing career in SE(PLSQL and Oracle, RDBMS) (Bucket list) at 30

[@jupiterwar]

Great video indeed, I'm even thinking about put some subtitles so I could translate to the language of my Country....

[@kevinkline2392]

If you do, please let me know and I'll spread the word on social media.

[@rambokhan7287]

@31.40 you did not do a dbccdropcleanbuffers, the second time you ran the query it got read from the cache that is why it went from 11sec to 4 sec.

[@serhiizhadovets819]

First time they also were in buffer pool. Because when you insert rows these pages are put into puffer pool. They might be not on hard drive but definitely they will be in RAM

[@okeyokafor648]

So when the estimated # of rows and actual # of rows have a huge difference due to outdated stats, would running UPDATE STATISTICS command take care of this?

[@kevinkline2392]

Yes, exactly the way to fix it!

[@dineshmanoharan2423]

One thing I disagree is that Checkpoint doesn't clear bufferpool. It just writes the dirty pages to disk and mark them as clean pages in the buffer.

[@mksktube]

It's kind of funny seeing the MS SQL guys using the Apple MacBook....

[@amnindersokhi4817]

You should gain knowledge from them instead of making funn

[@mksktube]

When you gain a fraction of my kNNowledge may learn to have some fuNN... Though doubt you'll get ever on my level, so begin learning to have funn... But sure your H1B visa is a prove of the top notch knowledge...

[@necbranduc]

I think you might need a new keyboard, your N seems to be doubling occasionally in your text. Also, I'd be very curious about your knowledge, I'd like to learn as well. Do you have a blog or somewhere you post your ideas, a fraction of your knowledge?

[@mksktube]

Don't be too curious, I was ordering you in dozens and know exactly what you know...

[@yiyuan6844]

MARK

[@jasonxu7191]

Good?

[@soarindragon603]

I wonder if a case statement would fix the kitchen sink issue (1:07) if it's even still an issue. Something like this... 1=case when @CustomerID is null then 1 when Customer ID = @CustomerID then 1 Else 0 end

[@americanexe]

SQL "programmer" LOL!

[@erwinekkel9676]

Sql is harder to get right then Javascript, c# or. Net.