von Uwe Ricken | März 12, 2025 | 300, DB Engine, SQL Blog
When using table hints, a few rules should be recommende, which – if ignored – can quickly lead to performance problems. In the database of one of our customer’s software, UPDLOCK is used as a table hint to force a serialization of processes....
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...
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...
