db-Berater GmbH
  • Home
  • Services
  • Workshops 
  • Referenzen
  • Blog
  • Download
  • Kontakt
Seite wählen
Auto Update Statistics and Trivial Execution Plans

Auto Update Statistics and Trivial Execution Plans

von Uwe Ricken | Jan. 19, 2025 | 300, DB Engine, SQL Blog, Statistiken

Do you know when stale statistics are automatically updated in Microsoft SQL Server? What happens to stale statistics if your queries generate/use trivial execution plans? This article describes how SQL Server handles Auto Update Statistics in combination with Trivial...

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...

Pleasant side effect of EXISTS vs. JOIN

von Uwe Ricken | Jan. 3, 2025 | DB Engine, Indexierung, SQL Blog, Tipps und Tricks

This blog post was inspired by a post by Eric Darling on LinkedIn, where he shared his video on the topic of [NOT] EXISTS. A pleasant side effect of using EXISTS over JOIN concerns automatically created statistics in Microsoft SQL Server. Task description Find all...
Probleme mit BACPAC-Dateien und Statistiken

Probleme mit BACPAC-Dateien und Statistiken

von Uwe Ricken | Aug. 20, 2019 | DB Engine, Indexierung, SQL Blog

Vor kurzem erreichte mich die Email eines Teilnehmers von einem Workshop. In der Email wurde beschrieben, dass eine Abfrage, die in einer Datenbank [A] sehr schnell ausgeführt wird, nach dem Import auf dem gleichen Server als “Data Tier Application” ein sehr viel...

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