Category: A Join A Day

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