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