The Hidden Danger of Wildcard Operators In Join Operations

This article looks at one of the killers of performance at scale, SELECT *.

The Hash Join I

More Left Joins

Learn about SQL Joins on Multiple Columns

Learn about joining SQL Server tables together for a query when there is a need to join on multiple columns.

Join SQL Server tables where columns include NULL values

Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.

SQL Server JOIN Hints

You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.

Hash Join

JOIN technique

another way to join the tables