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 x641
plan explorer upload x455
asked: Sep 14, 2016 at 08:18 PM
Seen: 325 times
Last Updated: Sep 19, 2016 at 03:25 PM
Help Optimizing View
Nested block comments in SQL not displayed correctly
The query is taking around 13 minutes to execute where prior it was just fraction of seconds.
How can this query show > 10M reads?
Really High Estimation
Update on view over partitioned tables updating all clustered indexes
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.