Wow, pretty shocked to see that comment from Eric. While Brent is indeed awesome, I am very impressed with even just these first few mins of this first video in the series from Doug. I am sure it will help many, who don't understand statistics, execution plans, parameter sniffing. I mean, sure: different strokes for different folks. But I just had to offer a huge thumbs-up and thanks to Doug for this series, and to Brent for hosting it here (and sharing news of it today, at www.brentozar.com/archive/2020/03/a-bunch-of-free-sql-server-videos-on-youtube/).
Today , while trobleshooting a performance issue in production , I remembered this content ( I´ve watched all vídeos from this series ) and I´d like to thank you a lot for the very helpfull content. Statistics is quite relevant topic and you did a really great job explain it.
Metadata of a table. More specifically, the number of rows for each distinct value of a column. You can also create multi column statistics, but those arent very accurate as single column.
That's a great question - for more details on that, check out our Fundamentals of Parameter Sniffing class: training.brentozar.com/courses/enrolled/1336969
Wow, pretty shocked to see that comment from Eric. While Brent is indeed awesome, I am very impressed with even just these first few mins of this first video in the series from Doug. I am sure it will help many, who don't understand statistics, execution plans, parameter sniffing.
I mean, sure: different strokes for different folks. But I just had to offer a huge thumbs-up and thanks to Doug for this series, and to Brent for hosting it here (and sharing news of it today, at www.brentozar.com/archive/2020/03/a-bunch-of-free-sql-server-videos-on-youtube/).
Today , while trobleshooting a performance issue in production , I remembered this content ( I´ve watched all vídeos from this series ) and I´d like to thank you a lot for the very helpfull content.
Statistics is quite relevant topic and you did a really great job explain it.
can we have definition for Statistics? when we perform update Statistics what happen internally in that tables
Sure, keep watching the class. Enjoy!
Metadata of a table. More specifically, the number of rows for each distinct value of a column. You can also create multi column statistics, but those arent very accurate as single column.
I know it's a 4 year old video. You had OPTION (RECOMPILE) in your query, how could the cause for the bad plan be parameter sniffing?
That's a great question - for more details on that, check out our Fundamentals of Parameter Sniffing class: training.brentozar.com/courses/enrolled/1336969
Please Brent, keep doing your own videos, you're WAYYYYY better!