SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Grant Fritchey
Author:

Author Bio:
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.
Left Join Operators

Left Join Operators

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

Video Information
Publish Date:
September 09, 2008
Length:
1:2
Skill Level:
100
Rating:
3.62 out of 5

You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
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.



Must Be Logged In

References
Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions