Learn about ordering, grouping, and segmenting in #SQLServer execution plans, in the latest set of videos in the SQLServerFast Execution Plan Video Training. Over 2 hours and 40 minutes of content, for just $89.95 (until September 15).
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Video training update 2025 - SQLServerFast
There have not been any updates for the SQLServerFast Execution Plan Video Training for a long time. In fact, it’s already over one and a half year since the last set of videos was released! But that ...
sqlserverfast.com
September 13, 2025 at 12:55 PM
Learn about ordering, grouping, and segmenting in #SQLServer execution plans, in the latest set of videos in the SQLServerFast Execution Plan Video Training. Over 2 hours and 40 minutes of content, for just $89.95 (until September 15).
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
A few hours late - but the SQLServerFast Black Friday sale has now officially started. Until the end of the month, purchase prices for all my training videos are slashed in half!
sqlserverfast.com/video
sqlserverfast.com/video
The SQLServerFast Execution Plan Video Training - SQLServerFast
You know that performance of database queries is critical to the success of any application. Customers leave if the website feels slow. Reports that take too long to render are not used, however usefu...
sqlserverfast.com
November 1, 2025 at 2:25 PM
A few hours late - but the SQLServerFast Black Friday sale has now officially started. Until the end of the month, purchase prices for all my training videos are slashed in half!
sqlserverfast.com/video
sqlserverfast.com/video
Yet another step closer to completion of the #SQLServer Execution Plan Reference. I just added the page for the Fetch Query "operator". Plus, as usual, a bunch of smaller and larger updates to other pages.
sqlserverfast.com/epr/fetch-qu...
sqlserverfast.com/epr/change-l...
sqlserverfast.com/epr/fetch-qu...
sqlserverfast.com/epr/change-l...
Fetch Query - SQLServerFast
Introduction The Fetch Query “operator” is not actually an operator. It is the equivalent of the Language Element “operator” for one of the two queries contained in a cursor definition. The Fetch Quer...
sqlserverfast.com
May 29, 2026 at 12:49 PM
Yet another step closer to completion of the #SQLServer Execution Plan Reference. I just added the page for the Fetch Query "operator". Plus, as usual, a bunch of smaller and larger updates to other pages.
sqlserverfast.com/epr/fetch-qu...
sqlserverfast.com/epr/change-l...
sqlserverfast.com/epr/fetch-qu...
sqlserverfast.com/epr/change-l...
New blog post! In which I announce that I once more offer a 50% Black Friday discount on all SQLServerFast Execution Plan Training Videos, valid through the entire month of November!
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Black Friday 2025 - SQLServerFast
It’s October. Almost time for the annual Black Friday tradition, where companies prove how large their regular margins are by giving deep discounts to all their customers. Since the margin on my SQLSe...
sqlserverfast.com
October 11, 2025 at 1:26 PM
New blog post! In which I announce that I once more offer a 50% Black Friday discount on all SQLServerFast Execution Plan Training Videos, valid through the entire month of November!
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
I just published another blog post. Finally a technical post again. Here, I dive deep into the internal structure of JSON indexes in #SQLServer.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Storage structures 6 – JSON indexes - SQLServerFast
It’s time to continue the series on internals of storage structures. I already covered the more standard storage types in the parts about on-disk rowstore, columnstore indexes, memory-optimized storag...
sqlserverfast.com
July 17, 2026 at 10:59 AM
I just published another blog post. Finally a technical post again. Here, I dive deep into the internal structure of JSON indexes in #SQLServer.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Learn about ordering, grouping, and segmenting in #SQLServer execution plans, in the latest set of videos in the SQLServerFast Execution Plan Video Training. Over 2 hours and 40 minutes of content, for just $89.95 (until September 15).
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Video training update 2025 - SQLServerFast
There have not been any updates for the SQLServerFast Execution Plan Video Training for a long time. In fact, it’s already over one and a half year since the last set of videos was released! But that ...
sqlserverfast.com
September 8, 2025 at 12:28 PM
Learn about ordering, grouping, and segmenting in #SQLServer execution plans, in the latest set of videos in the SQLServerFast Execution Plan Video Training. Over 2 hours and 40 minutes of content, for just $89.95 (until September 15).
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
I just blogged with an update on my leukemia treatment. First days in hospital, and the work I have been doing.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Back in hospital - SQLServerFast
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer a...
sqlserverfast.com
March 15, 2026 at 7:04 PM
I just blogged with an update on my leukemia treatment. First days in hospital, and the work I have been doing.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
A new post in my #Leukemia diary is live. I talk about a week with insane ups and downs -- mostly mental.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Ups and downs - SQLServerFast
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost ...
sqlserverfast.com
March 31, 2026 at 7:01 PM
A new post in my #Leukemia diary is live. I talk about a week with insane ups and downs -- mostly mental.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
I just published the next entry in my ongoing Leukemia diary on my blog.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Change is the only constant - SQLServerFast
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost ...
sqlserverfast.com
June 27, 2026 at 2:14 PM
I just published the next entry in my ongoing Leukemia diary on my blog.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
I just blogged: A deep dive into hash tables, part 2.
Do we need to know the internal structure of a hash table? Well, not really. Is it fun to figure it out anyway? Oh yeah!
sqlserverfast.com/blog/hugo/20...
Do we need to know the internal structure of a hash table? Well, not really. Is it fun to figure it out anyway? Oh yeah!
sqlserverfast.com/blog/hugo/20...
A deep dive into hash tables, part 2 - SQLServerFast
In part 1 of this series, I laid the foundation to explore the structure of the hash table, as used by the Hash Match operator, by alleging and then proving that a Hash Match (Left Outer Join) returns...
sqlserverfast.com
August 30, 2025 at 1:20 PM
I just blogged: A deep dive into hash tables, part 2.
Do we need to know the internal structure of a hash table? Well, not really. Is it fun to figure it out anyway? Oh yeah!
sqlserverfast.com/blog/hugo/20...
Do we need to know the internal structure of a hash table? Well, not really. Is it fun to figure it out anyway? Oh yeah!
sqlserverfast.com/blog/hugo/20...
Exactly a month after the last post in my leukemia diary, I have written another update. About that last month, but mostly the last week.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Another crazy week - SQLServerFast
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost ...
sqlserverfast.com
June 19, 2026 at 7:38 PM
Exactly a month after the last post in my leukemia diary, I have written another update. About that last month, but mostly the last week.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
I just published a MASSIVE update to the #SQLServer Execution Plan Reference. There are 4 new pages, for operations on JSON indexes, plus an additional 15(!) pages with various updates.
Check out the Change Log for a full overview.
sqlserverfast.com/epr/change-l...
Check out the Change Log for a full overview.
sqlserverfast.com/epr/change-l...
Change log - SQLServerFast
This site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider inte...
sqlserverfast.com
July 19, 2026 at 11:05 AM
I just published a MASSIVE update to the #SQLServer Execution Plan Reference. There are 4 new pages, for operations on JSON indexes, plus an additional 15(!) pages with various updates.
Check out the Change Log for a full overview.
sqlserverfast.com/epr/change-l...
Check out the Change Log for a full overview.
sqlserverfast.com/epr/change-l...
Time for a new update of my Leukemia Diary. Only good news this time!
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Home for now - SQLServerFast
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer and other similar diseases.) In my previous post, I wrote about the ups and downs as I was...
sqlserverfast.com
April 9, 2026 at 11:26 AM
Time for a new update of my Leukemia Diary. Only good news this time!
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
To be where I need to be (while really wishing I was somewhere else!)
New blog post with an update on my leukemia situation.
sqlserverfast.com/blog/hugo/20...
New blog post with an update on my leukemia situation.
sqlserverfast.com/blog/hugo/20...
To be where I need to be - SQLServerFast
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost ...
sqlserverfast.com
March 23, 2026 at 7:57 PM
To be where I need to be (while really wishing I was somewhere else!)
New blog post with an update on my leukemia situation.
sqlserverfast.com/blog/hugo/20...
New blog post with an update on my leukemia situation.
sqlserverfast.com/blog/hugo/20...
I wrote a new page for the #SQLServer Execution Plan Reference. Two in fact. Both for the little known Put operator.
sqlserverfast.com/epr/put/
And, as always, a bunch of other updates too.
sqlserverfast.com/epr/change-l...
sqlserverfast.com/epr/put/
And, as always, a bunch of other updates too.
sqlserverfast.com/epr/change-l...
Put - SQLServerFast
Introduction The Put operator is used to insert data in external (Polybase) tables. This operator was introduced in SQL Server 2016. At that time, the only writeable Polybase target was Hadoop. That c...
sqlserverfast.com
August 4, 2025 at 1:09 PM
I wrote a new page for the #SQLServer Execution Plan Reference. Two in fact. Both for the little known Put operator.
sqlserverfast.com/epr/put/
And, as always, a bunch of other updates too.
sqlserverfast.com/epr/change-l...
sqlserverfast.com/epr/put/
And, as always, a bunch of other updates too.
sqlserverfast.com/epr/change-l...
Time for another (short) update on my leukemia situation:
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Slow progress is better than no progress - SQLServerFast
(Warning: This blog post is non-technical but purely personal. In my leukemia diary, I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost ...
sqlserverfast.com
July 16, 2026 at 11:20 AM
Time for another (short) update on my leukemia situation:
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Forced by circumstances, I had to build my own shop for the SQLServerFast Execution Plan Video Training. This shop is now live! Read all about it in my latest blog post:
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
New shop! - SQLServerFast.com
Two and a half months ago, I informed you that Vimeo decided to shut down their VOD service, forcing me to find a new platform for hosting my videos and handling the sales. For me, that meant a lot of...
sqlserverfast.com
September 30, 2026 at 10:58 AM
Forced by circumstances, I had to build my own shop for the SQLServerFast Execution Plan Video Training. This shop is now live! Read all about it in my latest blog post:
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
I just published another update to the #SQLServer Execution Plan Reference.
Two new pages: COND and COND WITH QUERY.
Three updated pages: Plan properties, Table Spool, and Window Spool.
All links are here: sqlserverfast.com/epr/change-l...
Two new pages: COND and COND WITH QUERY.
Three updated pages: Plan properties, Table Spool, and Window Spool.
All links are here: sqlserverfast.com/epr/change-l...
Change log - SQLServerFast
This site has different types of readers. Those that come here to quickly look up something, using it as the reference this is. And those that read everything, or at least the pages they consider inte...
sqlserverfast.com
August 24, 2026 at 12:20 PM
I just published another update to the #SQLServer Execution Plan Reference.
Two new pages: COND and COND WITH QUERY.
Three updated pages: Plan properties, Table Spool, and Window Spool.
All links are here: sqlserverfast.com/epr/change-l...
Two new pages: COND and COND WITH QUERY.
Three updated pages: Plan properties, Table Spool, and Window Spool.
All links are here: sqlserverfast.com/epr/change-l...
November is Black Friday month!
Don't miss your chance to purchase access to the SQLServerFast Execution Plan Video Training with a whopping 50% discount! Offer runs until the end of the month.
#SQLServer
sqlserverfast.com/blog/hugo/20...
Don't miss your chance to purchase access to the SQLServerFast Execution Plan Video Training with a whopping 50% discount! Offer runs until the end of the month.
#SQLServer
sqlserverfast.com/blog/hugo/20...
Black Friday 2025 - SQLServerFast
It’s October. Almost time for the annual Black Friday tradition, where companies prove how large their regular margins are by giving deep discounts to all their customers. Since the margin on my SQLSe...
sqlserverfast.com
November 21, 2025 at 4:36 PM
November is Black Friday month!
Don't miss your chance to purchase access to the SQLServerFast Execution Plan Video Training with a whopping 50% discount! Offer runs until the end of the month.
#SQLServer
sqlserverfast.com/blog/hugo/20...
Don't miss your chance to purchase access to the SQLServerFast Execution Plan Video Training with a whopping 50% discount! Offer runs until the end of the month.
#SQLServer
sqlserverfast.com/blog/hugo/20...
New blog! In which I continue my series on storage structures, this time focusing on the (little used) memory-optimized columnstore index.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Storage structures 4 – Memory-optimized columnstore - SQLServerFast
Time for the next part in my series on storage structures. The previous parts covered on-disk rowstore, columnstore indexes, and memory-optimized storage. In this part, I will look at the combination ...
sqlserverfast.com
May 27, 2026 at 9:05 AM
New blog! In which I continue my series on storage structures, this time focusing on the (little used) memory-optimized columnstore index.
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
From the not-so-good news department: Hugo Kornelis' leukemia has returned: sqlserverfast.com/blog/hugo/20...
Return to the diary - SQLServerFast
(Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer…
sqlserverfast.com
March 5, 2026 at 9:10 PM
From the not-so-good news department: Hugo Kornelis' leukemia has returned: sqlserverfast.com/blog/hugo/20...
I'm trying something new (for me) this year: blogging in video format! My first one is up. Are you aware what happens to results and performance when you use the defaults of the OVER clause?
#sqlserver
sqlserverfast.com/blog/hugo/20...
#sqlserver
sqlserverfast.com/blog/hugo/20...
A new experiment for 2026 - SQLServerFast
It is January 1st, 2026. So let me first use this opportunity to wish all my readers a very good 2026, with lots of performance gains in your servers, lots of new insights into SQL Server, … but most ...
sqlserverfast.com
January 1, 2026 at 12:20 PM
I'm trying something new (for me) this year: blogging in video format! My first one is up. Are you aware what happens to results and performance when you use the defaults of the OVER clause?
#sqlserver
sqlserverfast.com/blog/hugo/20...
#sqlserver
sqlserverfast.com/blog/hugo/20...
Over the past months, I have published extensive updates to some of my existing Execution Plan Video Training videos for #SQLServer. Read all about how this affects you ... and how to benefit before the prices go up!
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...
Video training update 2026 - SQLServerFast
During the past months, in between working on new videos, I have also made various updates to existing videos in the SQLServerFast Execution Plan Video Training. Since I pushed two really big updates ...
sqlserverfast.com
June 13, 2026 at 2:14 PM
Over the past months, I have published extensive updates to some of my existing Execution Plan Video Training videos for #SQLServer. Read all about how this affects you ... and how to benefit before the prices go up!
sqlserverfast.com/blog/hugo/20...
sqlserverfast.com/blog/hugo/20...