On what basis does someone thumbs-down a presentation of this caliber? I realize that goes on all the time, but as far I'm concerned -- if you're gonna give a thumbs-down for this kind of quality, you damn well better have something to offer as to why. Anyway, thank you once again for your top-notch work! Very much enjoyed it, and it most certainly filled in some gaps in my understanding -- and then some!!. . . .
Bansal, even the 25% of data has changed, but the row count hasn't changed. As stats are for cardinality estimate or the row counts, how update stats here helps query optimizer ?
On what basis does someone thumbs-down a presentation of this caliber? I realize that goes on all the time, but as far I'm concerned -- if you're gonna give a thumbs-down for this kind of quality, you damn well better have something to offer as to why.
Anyway, thank you once again for your top-notch work! Very much enjoyed it, and it most certainly filled in some gaps in my understanding -- and then some!!.
. . .
Bansal , What an explanation....excellent....please post more videos like this
Really nice video, congrats! BTW the _WA stands for Waterloo, it's a legacy code from Sybase era. =)
Superb explanation. Thanks
Bansal, even the 25% of data has changed, but the row count hasn't changed. As stats are for cardinality estimate or the row counts, how update stats here helps query optimizer ?
Hello, Can we do a partial stats update like 20% or 50% on a table, if yes then please help with command
Stats are stored in which system DB?
Very useful info... Very well explained... Thank you
sp_helpstats has been removed in the actual version of Microsoft SQL Server
Excellent explanation
Excellent.. where can I get the complete course?
Great presentation. Can you share more vDs of the statistics?
Great explanation
Awesome videos... Very Well described
Great video. Thanks
Great vidio it really helped
Clear and crisp
Thanks
Great Explanation.
Very helpful
thanks
great
2