Category: Fundamentals

• A Join A Day – Except

  

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

  The EXCEPT keyword can be used to calculate the set theoretical difference of two sets of rows. You can use EXCEPT every time you want to return rows from one table that are not in another table. Under the covers SQL Server uses a Left Anti Semi Join too fulfill an EXCEPT requests.

  [more…]

• A Join A Day – Intersect

  

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

  INTERSECT is a keyword that takes two query expressions and calculates the set theoretical intersection from the two row sets. Under the covers SQL Server often uses the Left Semi Join operator for INTERSECT queries. One peculiarity is, that duplicate rows will be removed from the final result.

  [more…]

• A Join A Day – Right Anti Semi Join

  

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

  The Right Anti Semi Join, like the Right Semi Join, does not have a corresponding T-SQL statement. In the right circumstances however, the SQL Server optimizer will use the Right Anti Semi Join operator to build an efficient plan.

  [more…]

• A Join A Day – The Left Anti Semi Join

  

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

  The Left Anti Semi Join is the polar opposite of the Left Semi Join. While it also only returns data from the left table, it returns only those rows that are not returned by the Left Semi Join. Read on to find out how to use it.

  [more…]

• A Join A Day – The Right Semi Join

  

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

  The right semi join works like the left semi join, it just switches the role of the two sides. A Right Semi Join returns only rows from the right side base on the existence of matching rows on the left.

  [more…]