Visualizing Hash Match Join Internals And Understanding Their Implications
This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).
Watch...
2019-01-02
2 reads
Bert Wagner
Visualizing Hash Match Join Internals And Understanding Their Implications
This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).
Watch...
2019-01-02
8 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
4 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as...
2019-01-01
992 reads
2018 Community Influencer of the Year
A few days ago I was surprised to learn from Aaron Bertrand of SentryOne that he was selecting me as Community Influencer of the Year for 2018.
Aaron states that...
2019-01-01
2 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 – nested...
2018-12-31 (first published: 2018-12-18)
2,989 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
22 reads
Visualizing Merge Join Internals And Understanding Their Implications
This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...
2018-12-18
9 reads
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).
Watch...
2018-12-11
18 reads
Visualizing Nested Loops Joins And Understanding Their Implications
This post is the first in a series about physical join operators (be sure to check out part 2 – merge...
2018-12-11
878 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers