SQL SERVER – Not Auto-Updating Statistics with STATISTICS_NORECOMPUTE


 

Recently I found an interesting situation with one of my clients when working on Comprehensive Database Performance Health Check. It was about one particular statistics not getting auto-updated on the table. After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today.

Real-World Scenario

During the consultancy senior, DBA showed me a very strange scenario that one particular statistics was never getting updated automatically even though the threshold of the statistics updated was met. They always had to manually update that one particular statistics.

Now while it was alright for them to update statistics for that