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 | Jan. 1, 2025 | SQL Blog
Do you also think that an INDEX REBUILD triggers a FREEPROCCACHE? Things always get a little quieter between Christmas and New Year and you do things that you don’t have as much time for during the rest of the year. For example, you might watch a few SQL...
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....
