In Plan Explorer, if I enter command text like:
/* foo /*foobar*/ select 1 as one */
The select statement displays as if it is not in a comment (but it is)
Thanks for reporting, I've passed this along.
We've logged a bug on this one, but please note this is just a visual discrepancy. When you run the code, the select 1 as one doesn't actually execute (in other words, the outer comments are still obeyed).
select 1 as one
Attachments: Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.
Answers
Answers and Comments
Topics:
query plan x631 plan explorer upload x445 sql x39 comments x1
asked: Sep 14, 2016 at 08:09 PM
Seen: 115 times
Last Updated: Sep 19, 2016 at 03:26 PM
Help Optimizing View
The query is taking around 13 minutes to execute where prior it was just fraction of seconds.
END CATCH appears on two lines in the Results
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?
