Blog

• A Join A Day – The Left Anti Semi Join

  

  2012-12-14 - A Join A Day, Fundamentals, General, Series

  The Left Anti Semi Join is the polar opposite of the Left Semi Join. While it also only returns data from the left table, it returns only those rows that are not returned by the Left Semi Join. Read on to find out how to use it.

  [more…]

• A Join A Day – The Right Semi Join

  

  2012-12-13 - A Join A Day, Fundamentals, General, Series

  The right semi join works like the left semi join, it just switches the role of the two sides. A Right Semi Join returns only rows from the right side base on the existence of matching rows on the left.

  [more…]

• A Join A Day – The Left Semi Join

  

  2012-12-12 - A Join A Day, Fundamentals, General, Series

  The Left Semi Join is a half join: It only includes rows from the left side in the results. A typical example for a left semi join query is a statement containing the EXEISTS keyword. However, this does not always result in an execution plan with a Left Semi Join operator.

  [more…]

• A Join A Day – How to Test a Join

  

  2012-12-11 - A Join A Day, General, Series, T-SQL Tuesday, TDD, tSQLt

  This is an advanced article showing how to use the “0-1-some” heuristic to select the right test cases when unit testing a join query. The example will approach the task following Test Driven Design.

  [more…]

• A Join A Day – A Self-Join Experience

  

  2012-12-10 - A Join A Day, Fundamentals, General, Series

  A self-join is not something that is provided by a special join command. It’s just a term for the pretty mundane idea of joining a table to itself. But rest assured – there is more behind it… [more…]

• A Join A Day – The Outer Apply

  

  2012-12-09 - A Join A Day, Fundamentals, General, Series, T-SQL Statements

  This is day nine of the A Join A Day series and we are going to look at the outer apply statement. We will discover the differences to the cross apply and the similarities to the left outer join. Read on to get all the details.

  [more…]

• A Join A Day – The Cross Apply

  

  2012-12-08 - A Join A Day, Fundamentals, General, Series, T-SQL Statements

  The Cross Apply is the topic of this eighth day of the A Join A Day series. The Cross Apply is a unique T-SQL statement that allows us to join a table to a function. Read on for all the details…

  [more…]

• A Join A Day – The Full Outer Join

  

  2012-12-07 - A Join A Day, Fundamentals, General, Series, T-SQL Statements

  The full outer join combines the functionality of the left outer join and the right outer join. This post sheds light on this join type and reviles another surprise when we look at the execution plan for a full outer join query.

  [more…]

• A Join A Day – The Right Outer Join

  

  2012-12-06 - A Join A Day, Fundamentals, General, Series, T-SQL Statements

  On this sixth day of my A Join A Day series the topic is the right outer join. We are going to compare the right outer to the left outer join and we will see the SQL Server usually avoids them.

  [more…]

• A Join A Day – The Left Outer Join

  

  2012-12-05 - A Join A Day, General, Series, T-SQL Statements

  In this fifth post of my A Join A Day series we are going to examine the left outer join. Learn about the difference to an inner join, the importance of the ON clause and take a look at the left join operator used in execution plans.

  [more…]