Changes to auto update stats thresholds in SQL Server 2016
11 Comments
TL;DR As of CTP 3.3, it’s the same behavior as Trace Flag 2371, in 2008 R2 SP1 and onward. That basically means that the bigger your table is, the fewer rows need to be modified before an automatic statistics update occurs. Slightly longer… The change was announced over here. At first I thought, woah, cool,…
Read More