Lightnews — Scholar-powered news

1 3

Hugo Kornelis @hugokornelis.bsky.social · 9d

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

A deep dive into hash tables, part 3 - SQLServerFast

Hugo Kornelis @hugokornelis.bsky.social · 12d

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

3

Hugo Kornelis @hugokornelis.bsky.social · 18d

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

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

2 4

Reposted by Hugo Kornelis

Rob Sewell He/Him @robsewell.com · 20d

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

1 2

Hugo Kornelis @hugokornelis.bsky.social · 26d

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

Hugo Kornelis @hugokornelis.bsky.social · Sep 15

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

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

Hugo Kornelis @hugokornelis.bsky.social · Sep 13

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

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

3 4

Hugo Kornelis @hugokornelis.bsky.social · Sep 8

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

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

2

Hugo Kornelis @hugokornelis.bsky.social · Sep 6

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!

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

A deep dive into hash tables, part 2 - SQLServerFast

Hugo Kornelis @hugokornelis.bsky.social · Sep 4

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

Hugo Kornelis @hugokornelis.bsky.social · Aug 30

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

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

A deep dive into hash tables, part 1 - SQLServerFast

1 9

Hugo Kornelis @hugokornelis.bsky.social · Aug 14

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

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

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

1 2

Hugo Kornelis @hugokornelis.bsky.social · Aug 4

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

Put - SQLServerFast

Change log - SQLServerFast

1 6

Hugo Kornelis @hugokornelis.bsky.social · Jul 6

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

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

Hugo Kornelis @hugokornelis.bsky.social · Jul 4

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

1 1

Hugo Kornelis @hugokornelis.bsky.social · Jul 4

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

1 2

Hugo Kornelis @hugokornelis.bsky.social · Jun 29

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.

1 3

Hugo Kornelis @hugokornelis.bsky.social · Jun 17

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!

1 1

Hugo Kornelis @hugokornelis.bsky.social · Jun 17

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!

2

Hugo Kornelis @hugokornelis.bsky.social · Jun 16

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

Hugo Kornelis @hugokornelis.bsky.social · Jun 14

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

Alt: Sheldon Cooper hyperventilating in a paper bag.

media.tenor.com

6

Hugo Kornelis @hugokornelis.bsky.social · May 30

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

Statistics Parser

statisticsparser.com

2 1

Hugo Kornelis @hugokornelis.bsky.social · May 14

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.

1 3

Hugo Kornelis @hugokornelis.bsky.social · May 14

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