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

Very useful info... Very well explained... Thank you

Great video. Thanks

Awesome videos... Very Well described

Clear and crisp

sp_helpstats has been removed in the actual version of Microsoft SQL Server

Great explanation

Great Explanation.

Excellent explanation

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

Excellent.. where can I get the complete course?

Great vidio it really helped

Very helpful

Great presentation. Can you share more vDs of the statistics?

Thanks

Stats are stored in which system DB?

thanks

great

2