
Archive:
- November 2026 (6)
- October 2026 (6)
- September 2026 (5)
- August 2026 (8)
- July 2026 (8)
- June 2026 (7)
- May 2026 (7)
Search site:
Tags:
Availability Groups (3) Concurrency (3) debian (4) docker (2) Execution Plans (7) Indexes (4) internals (12) linux (7) MongoDB (2) MR2 (2) Optimization (7) Performance (9) Performance Tuning (3) postgres (8) Powershell (3) RCSI (2) SQL Server (32) Statistics (2) Version Store (2) windows server (3)
Categories:
Docker (2) Linux (5) MongoDB (2) PostgreSQL (8) Powershell (2) SQL (1) SQL Server (33) Windows Server (3)
Month: May 2026
-
Physical Joins – Merge Join

In this series, we’ve been looking at the internals of physical joins – the operations SQL Server does behind the scenes to satisfy the logical joins written in our declarative T-SQL. So far, we’ve looked at nested loop joins and hash joins, and in this final post, we’ll look at the merge join. The Algorithm…
-
Physical Joins – Hash Join

Last Updated: May 18, 2026 In the previous post in this series, we looked at the nested loop operator which we saw was useful when there is a small set data and a second set of sorted data. In this post, we’ll look at what is often considered the workhorse of physical join operators –…
-
Physical Joins – Nested Loop

Last Updated: May 18, 2026 This post is the first in a short series about physical join types. What do I mean by physical join types? What we normally consider to be a join – INNER / [LEFT|RIGHT] OUTER / FULL join are logical join types, they are the joins we use to describe the…
-
Understanding SQL Server Statistics

Last Updated: August 12, 2026 The next post in this short introductory series is about statistics in SQL Server – this isn’t an all-encompassing deep dive into the topic – the aim is to outline what statistics are, where and how SQL Server uses them, present a quick overview of an example statistic and an…
-
Understanding SQL Server Indexes

Last Updated: July 23, 2026 This post follows on from the previous two about execution plans in SQL Server, in those posts I covered what an execution plan is, what they tell us and why we might need to use them. Indexes are actually nothing at all to do with execution plans but when talking…
-
More on Execution Plans

Last Updated: May 5, 2026 In my previous post on execution plans we looked at what an execution plan is, how SQL Server creates them and why we might use them, now we’ll delve a little further. Recap We very briefly compared two SQL Server execution plans on two queries against the Stack Overflow 2010…
-
SQL Server Execution Plans Explained

Last Updated: May 5, 2026 In these articles, you will see me reference execution plans a lot – talk about them, provide screenshots etc. I assume that the reader has some level of knowledge about what an execution plan is, how to view them and how to understand them. This post is aimed at those…