Opinionated Software

… we have opinions about everything!

Archive for the ‘Trace Flags’ Category

Trace Flag 2371 —

This trace flag (available in SQL Server 2008 R2 SP1 and later) alters the threshold calculation for auto statistics update on SQL Server instances so that larger tables do not require as many updates before statistics are updated i.e. the old 20% + 500 rows calculation does not apply for larger tables. Personally, I would […]