Tag: JOIN

TSQL JOIN Types Poster (version 4.1)

After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only a minor version upgrade due to only a small change. The thing I love about

Posted in Uncategorized Tagged with: , , , , , , ,

TSQL JOIN Types Poster (Version 4)

So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , , , , , ,

SQL Saturday Redmond

Yesterday I blogged about submitting to SQL Saturday Denver, which is about 5 months away, after writing that post, I realized that I haven’t even blogged about SQL Saturday Redmond which is occurring in just over 2 weeks. SQL Saturday

Posted in SQL Saturday Tagged with: , , , ,

TSQL JOIN Types Poster (Version 3)

NOTE:: There is an updated version of the poster available now.   Version 4 is now available. So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference

Posted in TSQL Tagged with: , , , ,

FULL OUTER JOIN vs CROSS JOIN

As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are

Posted in Uncategorized Tagged with: , , , ,

TSQL OUTER JOINS (LEFT and RIGHT)

After learning the INNER JOIN when querying SQL Server, the LEFT OUTER JOIN and RIGHT OUTER JOIN are often what people attempt to learn next. The reason that I say attempt is that most people don’t get OUTER JOINs right the

Posted in 70-461 Training Tagged with: , , , , , , ,

TSQL INNER JOIN

The INNER JOIN has to be the most common JOIN type in SQL Server. This is where we will start on our journey to understand all the JOIN types in SQL Server. The best way that I have discovered to

Posted in 70-461 Training Tagged with: ,

SQL Server Join Types Poster (Version 2)

So many times I have been asked for help with a query, where the questoin really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , ,

SQL Server Join Types Poster

This has been replaced with a new updated version of the poster. Click here to visit the new page.   So many times I have been asked for help with a query, where the questoin really comes down to the

Posted in TSQL Tagged with: ,

CTE Hierarchy compared to the alternative

After my CTE presentation at SQL Saturday 108 in Redmond, I was asked many questions, and received several great suggestions from people.  Based on that feedback, I am updating my presentation for SQL Saturday 114 in Vancouver to include some

Posted in CTE, Performance, SQL Saturday Tagged with: , , , , , , ,