Author Archives
-
Performance Woes & Wows #1: Implicit Conversions
Implicit conversion… Sounds very clever, so it can’t be that bad, right? Well, in fact, implicit conversions can be huge performance killers and silent enough to stay off the radar, if we are not aware. The good news is that… Read More ›
-
MemoryGrantInfo Info
As suggested by the title, I like redundancy, bad titles and we’re going to have a brief look into MemoryGrantInfo. In a previous post, we’ve talked about an awesome feature from the new SQL Server 2019 – Row Mode Adaptive… Read More ›
-
Rowstore Adaptive Joins
In this day and age, join operations in SQL Server can be made using one of the following algorithm types: Nested Loops, Merge or Hash. In theory, each one provides better performance under different conditions (e.g. amount of data). Nested… Read More ›
-
Row Mode Adaptive Memory Grant Feedback
Memory Grants Throughout the phases of query processing there are several memory consumers that the memory broker and the memory manager inside SQL Server try to handle efficiently. From those, compile, cache and memory grant are amongst the most significant. … Read More ›
-
posts.First();
The first New Year’s resolution is officially completed: Create a blog to share contents and experiences on my current main area of interest – SQL Server. I have this intention for a while now, I follow blogs from some of… Read More ›