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...
von Uwe Ricken | Jan. 6, 2025 | Administration, DB Engine, SQL Blog
How can SWITCH PARTITION be a bad idea? Do you work with partitioning and know the many advantages that this technology offers? Do you use this technology in DWH to improve workloads or in OLTP systems to optimize scaling? Be careful with SWITCH PARTITION. It should...
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...
von Uwe Ricken | Jan. 1, 2025 | SQL Blog
Do you also think that an INDEX REBUILD triggers a FREEPROCCACHE? Things always get a little quieter between Christmas and New Year and you do things that you don’t have as much time for during the rest of the year. For example, you might watch a few SQL...
von Uwe Ricken | Dez. 30, 2024 | DB Engine, Indexierung, SQL Blog, Statistiken
In the realm of data management, maintaining optimal query performance is paramount. Microsoft SQL Server provides a powerful feature—automatically generated statistics objects—that plays a crucial role in this endeavor. These statistics objects are vital for the...
