First time posting on here - did i post exec plan correctly?
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 x664
plan explorer pro upload x166
execution plan x121
slow query x47
asked: Jun 17, 2016 at 04:30 PM
Seen: 76 times
Last Updated: Jun 19, 2016 at 08:24 PM
Client's report is timing out. I'm at a loss as to where to begin trying to fix this mess.
Trying to figure out if there is a way to avoid the index scan and make it a seek in this plan. The query is performing fine, this is more for a learning opportunity for me.
Query runs slowly, although only indexes are involved. What should I concentrate on?
Help, SELECT * from view takes 2.5 hours
How to eliminate table spool
Poor perfomance, possiblly due to locks How can I better optimise
Running a query twice, the second one has less IO/cost?
The SSRS report wont show up in sql server 2005
TOP used before the predicate - feels like a Sql bug but certainly i am missing something
Query takes too long to complete
© 2013 SQL Sentry, Inc. All rights reserved.