|
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.
|
|
|
What is the Scalar Operator in a SQL Query Plan?
What does it mean when you see the scalar operator in a query plan? How do you determine what expression lead to the operator? Join Grant Fritchey for a quick overview and you'll find query plans much less frustrating to read.
|
Video Information
|
Publish Date:
|
September 09, 2008
|
Length:
|
1:16
|
Skill Level:
|
100
|
Rating:
|
3.96 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- If you see a scalar operator in a query plan, how do you determine what expression generated that operator?
- Scalar operators typically represent what portion of a query?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
|
Spending another 30 seconds on the video to tell us why this matters would have been nice.
|
|
|
I figured it'd be basic, but I didn't know about the "properties" trick.
|
|
Sara Karasik on 6/23/2009
Excellent presentation, (as usual) of something that I always wanted to know.
|
|
|
|
|
|
|