Is it possible that your statistics are many years old but still are valid for your SQL Server? Yes, It is difficult to find Outdated Statistics is not as easy as it seems. Many will argue that there is nothing outdated statistics and they are right at many count.
Yesterday I wrote a blog post SQL SERVER – Find Oldest Updated Statistics – Outdated Statistics and I got lots of feedback about it from my clients as well as blog readers. Based on their request, I have decided to build a video that discusses how to find outdated statistics and related discussions.
Here is the SQL in the Sixty Seconds video.
All the scripts used in this video are available for free over here. It is always recommended that you try out all of your experiments first on your development environment rather than production. It is needless to mention that you should update your statistics when your server is not busy to avoid any performance pressure on the busy server.
If you like what you see, I request you to subscribe to my YouTube Channel, where I discuss many such topics which you may find interesting. If you like any video on YouTube, you can always go back to your YouTube History and find the same video again easily.
Reference: Pinal Dave (https://blog.sqlauthority.com)