Category: General

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

• A Join A Day – The Cross Join

  

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

  In this 4th post of the ‘A Join A Day’ series we are going to take a detailed look at the cross join statement. The cross join is probably the simplest of all join commands, but it still has its surprises. Read on, to find out more.

  [more…]