Missing Index Impact and Join Type

Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.

SQL Server Join Example

What are all of the JOIN options in SQL Server? What is the significance of each of the options? How does the syntax work? Jeremy Kadlec answers these questions and more.

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins

Let’s Talk About Joins

T-SQL Tuesday #37
This month please join us in the TSQL blog party that happens on the second tuesday of the...

The Right Kind Of Join III

The Right Kind Of Join II

RE: SHOWCONTIG Data

Thanks Frank, I'd forgotten to add the update stats bit after the online defrag, but thought that Clive was experienced enough to know that anyway

RE: Can''''t get an outer join

I think I understand what you are getting at, but some sample data highlighting what you are currently getting and what you want to get would help significantly. To simplify this, please just include the tables/columns that are relevant to the SQL you have posted, to make it easier to read. Cheers Phil

RE: Get Previous Date

...well then