SQLServerCentral.com Articles tagged JOIN

SQL Server JOIN Hints

Mon, 08 Apr 2013 06:00:00 UT

You, as a SQL Server data professional, are looking for ways to improve your queries. You've done the usual - avoided cursors and loops, used locks effectively, examined execution plans - what else can you tweak? Check out this tip to learn more.

Join Operations – Nested Loops

Fri, 01 Feb 2013 07:00:00 UT

This is part I of III in a series on the physical join operators in SQL Server.

Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2

Wed, 30 Nov 2011 07:00:00 UT

Joining tables is a crucial concept to understanding data relationships in a relational database. When you are working with your SQL Server data, you will often need to join tables to produce the results your application requires. Having a good understanding of set theory, and the mathematical operators available and how they are used to join tables will make it easier for you to retrieve the data you need from SQL Server.

SQL and the JOIN Operator

Fri, 25 Feb 2011 07:00:00 UT