db-Berater GmbH
  • Home
  • Services
  • Workshops 
  • Referenzen
  • Blog
  • Download
  • Kontakt
Seite wählen

When „Auto Update Statistics“ will not update your statistics

von Uwe Ricken | Jan. 8, 2025 | SQL Blog

The database option „Auto Update Statistics“ ensures that statistics are automatically updated when a threshold is reached. Under certain conditions, these updated statistics are not considered Why is that? Statistics The query optimizer uses statistics to...

Helper function for determining the update threshold for statistics

von Uwe Ricken | Dez. 20, 2024 | Administration, Informationen, SQL Blog, Statistiken

In customer meetings, I am often asked about the formula that Microsoft SQL Server uses to automatically update statistics. I always have to look it up myself because this formula depends on a number of factors. For this reason, I decided to develop my own...

db SQL Blog

  • Table Hint UPDLOCK and LOCK ESCALATION
  • Auto Update Statistics and Trivial Execution Plans
    Execution process of trivial plans with simple parameterization
  • When „Auto Update Statistics“ will not update your statistics
  • Is SWITCH PARTITION a bad idea?
  • Pleasant side effect of EXISTS vs. JOIN
  • INDEX REBUILD is not FREEPROCCACHE
  • Automatically Created Statistics – know the caveats
  • Temporary Table or Table Variable, that is the question.
  • AUTO_UPDATE_STATISTICS and thresholds
  • Helper function for determining the update threshold for statistics
  • Partitioning and LOCK_ESCALATION = AUTO
  • The role of a DBA is NOT Tuning but Operations
  • Foreign Key Constraints – JOIN Elimination
  • Foreign Key Constraints – Part II
  • Use Foreign Key Constraints in your Databases – Part I
  • Datenschutzerklärung
  • Impressum
  • Sitemap
  • Download
  • RSS

db Berater GmbH | | Büchenweg 4 | 64390 Erzhausen | Phone: +49 (0) 6150 5082955 | E-Mail: info@db-berater.de Amtgericht Darmstadt: HRB86305 |    Umsetzung