von Uwe Ricken | Okt. 8, 2026 | 300, SQL Blog
CTE vs temp table performance in SQL Server is one of those evergreen debates that never seems to fade. The recent MSSQLTips article by Mehdi Ghapanvari compares both approaches and concludes that temp tables sometimes win because of better cardinality estimation...
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...
