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!
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
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?
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 presentation, very helpful. Thanks
@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
Great Content! Learned quite a bit...
very nicely explained. do you have something for oracle.. please share
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.
Excellent presentation ,Very Helpful
@1:16:22 - SQL 2016 adds STRING_SPLIT. Probably table-valued parameters are still better, though.
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.
Great Lecture !!
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!
Advancing career in SE(PLSQL and Oracle, RDBMS) (Bucket list) at 30
Thanks for this great video. Really helpful.
Thanks for this. Very useful.
سقس
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...
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
it is realy nice
Good?
MARK
SQL "programmer" LOL!
Sql is harder to get right then Javascript, c# or. Net.