Category: Fundamentals

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

• A Join A Day – The Inner Join

  

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

  This post looks at the inner join T-SQL command. After reading you will be able to use it and explain how it handles data and how to identify it in an execution plan.

  [more…]

• A Join A Day – Introduction

  

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

  In December 2012 I am going to publish one post per day about SQL Server Joins. With topics ranging from fundamentals to internals there should be something interesting in there for everyone.

  [more…]