SQL Server Statistics Basics - Part 1 (by Amit Bansal)

[@rickmemmer5625]

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!!. . . .

[@priyankamakker459]

Superb explanation. Thanks

[@_HugoQueiroz]

Really nice video, congrats! BTW the _WA stands for Waterloo, it's a legacy code from Sybase era. =)

[@MSARAVAI]

Bansal , What an explanation....excellent....please post more videos like this

[@sandykoolz]

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 ?

[@robk4099]

Excellent explanation

[@dineshpanchalMCA]

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

[@alianwar2433]

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

[@Worldinfonews]

Great explanation

[@MadhukarTiwari-k8j]

Hello, Can we do a partial stats update like 20% or 50% on a table, if yes then please help with command

[@Sri3051]

Excellent.. where can I get the complete course?

[@payalsharma2248]

Awesome videos... Very Well described

[@prajwalkumar8292]

Great vidio it really helped

[@Farisito]

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

[@UnfilteredStories]

Stats are stored in which system DB?

[@shaikhussain474]

Clear and crisp

[@nicolasrepetti]

Thanks

[@photukumar8323]

Great video. Thanks

[@JyotiSingh-sz7ox]

Great Explanation.

[@marshallt8353]

Very helpful

[@srinivasv3282]

thanks

[@chihebkraiem]

great

[@Ramesh_Anandh]

2