von Uwe Ricken | Aug. 6, 2026 | DB Engine, Indexierung, Partitioning, SQL Blog, Tipps und Tricks
Today, I came across a post by Michael J. Swart on LinkedIn in which he presented a variation – based on his blog article „Partitioning a Huge Table Quickly“ – of how to implement partitioning with minimal impact on application performance. I...
von Uwe Ricken | Nov. 4, 2025 | 200, DB Engine, SQL Blog
How often do you read on blogs and/or social media platforms that it simplifies work to use „1 = 1“ as the first statement in a WHERE clause, followed by „AND…“ in subsequent lines? Some comments point out that it’s pointless, while...
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...
