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