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 | 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...
von Uwe Ricken | Dez. 28, 2024 | DB Engine, Optimierung, SQL Blog, Statistiken, Tipps und Tricks
Which technique do you prefer when you create a stored procedure and need to work with temporary data? We know there is no definitive answer to this, but there are workloads where a Table Variable is always preferable to a Temporary Table. Workload The stored...
von Uwe Ricken | Dez. 21, 2024 | 300, DB Engine, SQL Blog, Statistiken
This week I was called out twice to an incident at a customer’s site where a massive blocking problem occurred in the web shop. The root cause was the AUTO_UPDATE STATISTICS option. One blog article is not enough to explain the complexity of this problem....
von Uwe Ricken | Dez. 9, 2024 | 200, DB Engine, SQL Blog
JOIN Elimination in Microsoft SQL Server is an optimization technique with foreign key constraints where the query engine removes redundant JOIN operations during query execution. This occurs when the data from the joined table is not used in the SELECT clause or any...
