I have sql like:
After getting an estimated plan, I get two lines in the statement tree:
Thanks, I can repro this issue, we'll investigate.
It seems that this is how the query text is rendered in the XML we received from SQL Server - there is a carriage return and line feed in that very spot, which makes it render that way in our statement tree.
Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers and Comments
query plan x676
plan explorer upload x489
asked: Sep 14, 2016 at 08:18 PM
Seen: 373 times
Last Updated: Sep 19, 2016 at 03:25 PM
Help Optimizing View
The query is taking around 13 minutes to execute where prior it was just fraction of seconds.
Nested block comments in SQL not displayed correctly
How can this query show > 10M reads?
Update on view over partitioned tables updating all clustered indexes
Really High Estimation
Query finishes in SSMS not in PE
alt-select doesn't work properly
Alt-mouse select doesn't work as expected
Where do I begin?
© 2013 SQL Sentry, Inc. All rights reserved.