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!
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?
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
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...
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?
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
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!
Great Content! Learned quite a bit...
great presentation, very helpful. Thanks
Thanks for this great video. Really helpful.
Great Lecture !!
Excellent presentation ,Very Helpful
Thanks for this. Very useful.
سقس
very nicely explained. do you have something for oracle.. please share
Advancing career in SE(PLSQL and Oracle, RDBMS) (Bucket list) at 30
Great video indeed, I'm even thinking about put some subtitles so I could translate to the language of my Country....
If you do, please let me know and I'll spread the word on social media.
it is realy nice
@1:16:22 - SQL 2016 adds STRING_SPLIT. Probably table-valued parameters are still better, though.
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?
Yes, exactly the way to fix it!
@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.
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
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.
It's kind of funny seeing the MS SQL guys using the Apple MacBook....
You should gain knowledge from them instead of making funn
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...
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?
Don't be too curious, I was ordering you in dozens and know exactly what you know...
MARK
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
Good?
SQL "programmer" LOL!
Sql is harder to get right then Javascript, c# or. Net.