Left Join Operators

This video explains what a left join operator is when looking at a query plan.

I'm currently working for FM Global, an industry leading engineering & insurance company, as a DBA. I've done development of large scale applications in languages such as VB, C# and Java. I've worked in SQL Server from the hoary days of 6.0. My nickname at work is the "The Scary DBA." I even have an official name plate with it. I wear it proudly. I was awarded a Microsoft MVP in April of '09.

Rizwan Gulamhussein on 11/6/2008

Good quick explanation of cost and looking at query plans. Would love to see a video on what to do to enhance the query. Also, if the query is converted to a stored proc, would the cost of execution still be the same? Thanks! Riz

ML Stephens on 11/6/2008

great, didn't bore me with "How do you make a left join?" focusing on execution plan showed me simplely what I didn't know. Really shows me no matter how simplistic the title is, watching your videos will definately be something not to pass up.

Jimmy May on 11/6/2008

Nice introduction--succinct & byte-sized. My apetite is whetted. What is next on the plate, eh?

Nuno Costa on 11/6/2008

just shows the execution plan , it does't explain the query, how to avoid probelems of performance

Marco Francisco on 11/9/2008

Nice Grant. Bring more of these and talk more about tunning and execution plans. Nice work. Thanks.

58039FCE90 on 1/6/2009

more info on query join performance

Diana Dee on 3/8/2009

What was the query? What is the context?

Grant Fritchey on 3/9/2009

Sorry, there wasn't a context intended. This was just meant as an introduction to the operator.