curious_sqldba (11/7/2013)
Keith Tate (11/6/2013)
That is simply the name of the output (one of them) from the Compute Scalar operation right before the sort. Also, you have some carnality issues with this query (not sure if this is a real query or not), but the estimated rows and the actual rows are way off in some instances.But then why is it showing a column name for the other one?
The scalar operator immediately before the sort is calculating the value of [Expr1088]. Included in the output of the scalar operator is the new expression [Expr1088] and the column [Column7]. The sort operator is then sorting on [Expr1088] and [Column7].
In other words, [Expr1088] is a calculated value while [Column7] is a value from your table.
