Category: Fundamentals

• 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 – 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…]