|
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
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.
|
|
|
|
|
|
Comments:
|
|
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
|
|
|
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.
|
|
|
Nice introduction--succinct & byte-sized. My apetite is whetted. What is next on the plate, eh?
|
|
|
just shows the execution plan , it does't explain the query, how to avoid probelems of performance
|
|
|
Nice Grant.
Bring more of these and talk more about tunning and execution plans.
Nice work.
Thanks.
|
|
|
more info on query join performance
|
|
|
What was the query? What is the context?
|
|
|
Sorry, there wasn't a context intended. This was just meant as an introduction to the operator.
|
|
|
|
|
|
|