Category: A Join A Day

• A Join A Day – Loop Join Limitations

  

  2012-12-26 - A Join A Day, General, Series, SQL Server Internals

  Which logical join types can be handled by the Loop Join operator and which can’t? Where does the optimizer have to jump through hoops to generate a query plan? This article gives answers to these questions.

  [more…]

• A Join A Day – The Life Join

  

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

  Today’s post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.

  [more…]

• A Join A Day – Predicate, Probe & Residual

  

  2012-12-24 - A Join A Day, General, Series, SQL Server Internals

  This article talks about predicates, probes and residuals, all of which are used in different places of different join queries. This knowledge can help you to identify why your join query is slow and where it is spending its time.

  [more…]

• A Join A Day – The Hash Join

  

  2012-12-23 - A Join A Day, General, Performance, Series, SQL Server Internals

  This article introduces the Hash Join algorithm The Hash Join algorithm and shows in which situations it is a good choice. This algorithm is the most CPU and memory intensive one but if you are dealing with large tables it will often also be the fastest.

  [more…]

• A Join A Day – The Sort Merge Join

  

  2012-12-22 - A Join A Day, General, Performance, Series, SQL Server Internals

  This article introduces the Sort Merge Join algorithm. It shows its strengths and weaknesses to help you identify query situations for which the Merge Join operator in the execution plan is an appropriate choice.

  [more…]