Hugo Kornelis

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

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

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

No, it makes perfect sense. One for each week of the year, and you get 1 or 2 days off at the end of the year.

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

So what's the dilemma? Which one to finish?

It's always beer o'clock somewhere in the world.
(Perhaps even at the departure or arrival airport of the beer drinking traveller)

A deep dive into hash tables, part 3 - SQLServerFast Welcome back! In the previous parts, I first showed how a Hash Match (Left Outer Join) can give insight in the order of data in a hash table, and then used that trick to obtain and verify some interes...

New blog post live! In part 3 of the deep dive into hash tables, I will show you how to use our knowledge of the structure of the hash table to identify hash collisions from looking at query results.
#SQLServer

sqlserverfast.com/blog/hugo/20...

A sticker saying You can be anything be kind in purple lettering on a black background

I can take a look. Depends on the type of question, I guess.

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

LAST CHANCE! Early bird expires today!

Learn about ordering, grouping, and segmenting in #SQLServer execution plans, in the latest part of the SQLServerFast Execution Plan Video Training. Over 2 hours and 40 minutes of content, with $10 off!

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

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

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

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

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

The long wait is finally over!
The basic level of block 6 of the SQLServerFast Execution Plan Video Training, on sorting, grouping, and segmenting, is now available!

Read all about it: sqlserverfast.com/blog/hugo/20...
And then hurry up and buy access. Early bird pricing lasts until September 15!

I'll admit that I have not played with JSON indexes yet.
I assume they'll work very similar to XML indexes.

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

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

A deep dive into hash tables, part 1 - SQLServerFast We all know the Hash Match operator. It joins or aggregates data, based on a hash table. That hash table is ideally stored in memory. But if the granted memory is insufficient, then Hash Match will sp...

It's been a long time since I last blogged. But today, I did!

Part 1 of a series that will probably be at least four parts, and where we'll be wasting our time to look into the internals of hash tables in #SQLServer. Geek out!

sqlserverfast.com/blog/hugo/20...

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

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

A new update to the #SQLServer Execution Plan Reference!
* Added all the different names of the Result and Language Element operators to the list of all operators.
* Added a change log at the end of each page.
* Various other changes
sqlserverfast.com/epr/change-l...

Ooh, execution plan pr0n. I like it!
"Nested Loops bares it all!"

If your goal is more views, I can suggest an alternate keyword list that is bound to work great. 😜

In case you get more offers than your friend can take ... I'm also very good with T-SQL optimization and DB development, and open to (more) work. So feel free to send any excess my way.

Of course. Let's be clear. I didn't mean to suggest one should never use the speaker room. It's there for a reason. I also retreat there at times.
The people I meant are those who only leave the speaker room for their session.
And please don't mistake my not understanding for judgement!

I agree. The payment is fine.
I also don't see the problem with the "No flyby" rule, but perhaps that's me. I've never understood speakers who lock themselves in the speaker room all day, or deliver a session and then go sightseeing. There's so much value in other sessions and/or networking!

I can't read the article, it requires a subscription.
But when I look at the graph, I see a spike in food orders at 6PM.
D'oh. That's supper time for many. I'd be more surprised to *not* see a spike in food orders at that time.

a man in a green shirt is eating a sandwich with the words life on mars on the bottom right Alt: Sheldon Cooper hyperventilating in a paper bag.

When your laptop won't connect to the projector, and you have to present on a borrowed laptop ... which doesn't have your demo data ... and which uses Slovenian (??) Keyboard mapping.
#DataSatCroatia
/cc @DejanSarka

That's great to hear!
I literally earlier today showed statisticsparser.com to a room of attendees at #DataPoint Prague.

I'm still not feeling well, but my voice recovered enough that I can at least start my presentation today. And, hopefully, make it until the end. Come see me at #sqlday, room A, 15:00, if you want to learn about approximate functions in #SQLServer.

I'm very sorry to hear this.
Hopefully you'll find a great new opportunity soon.

Aanstaande vrijdag, zaterdag en zondag speelt amateur musical groep Jabber in Arnhem de voorstelling "Jackpot!". Zin in twee uurtjes vermaak? Zin om mij te zien zonder dat ik over execution plans praat? Er zijn nog kaarten!
www.jabbertheater.nl/winkel/

Op 9, 10, en 11 mei speelt musical vereniging Jabber in Arnhem onze jaarlijkse voorstelling. Dus, heb je zin in een uitje? Wil je mij eens zien en horen in een heel andere rol? Wees welkom!
www.jabbertheater.nl