Talk in English - US at SQLSaturday #615 Baltimore 2017
Track Name:
Application & Database Development
Short URL: https://joind.in/talk/0f354
(QR-Code (opens in new window))
Are your statistics up to date?
Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that?
In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.
Comments
Comments are closed.