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!!.
. . .
Really nice video, congrats! BTW the _WA stands for Waterloo, it's a legacy code from Sybase era. =)
Bansal , What an explanation....excellent....please post more videos like this
Superb explanation. Thanks
Hello, Can we do a partial stats update like 20% or 50% on a table, if yes then please help with command
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 ?
Excellent explanation
Very useful info... Very well explained... Thank you
Great presentation. Can you share more vDs of the statistics?
Great explanation
sp_helpstats has been removed in the actual version of Microsoft SQL Server
Excellent.. where can I get the complete course?
Awesome videos... Very Well described
Great vidio it really helped
Clear and crisp
Great video. Thanks
Stats are stored in which system DB?
Thanks
Great Explanation.
Very helpful
thanks
great
2