Joins Dissected on CraigFr’s blog

CraigFr has a great series of posts in his blog describing the difference between the various logical and physical join types, the details of how SQL Server implements these joins, and the things that the query optimizer takes into account when selecting a join type.  These five posts are a wonderful read.  
Skip to main content