You have billions of rows coming out of table-valued functions that you've anonymized away. We have no idea what this query is trying to do, or why.
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 upload x474
poor performance x111
sql server x21
asked: Dec 07, 2016 at 01:56 PM
Seen: 617 times
Last Updated: Jan 08, 2017 at 05:06 PM
Help with query optimization
Need help in right direction to tune this Long running query with high cost in the Prod
Trying to understand why partition elimination is happening in some plans, but not others
Slow query - I think my index is just making things worse :(
How do I get this query to finish and not peg my CPUs?
Need help in tuning this select query which takes 2hrs
High cost for both Index scans and index seeks.
Query with many joins and subqueries slowing the server if more than one execution concurrently
this query timeout many times and runs successfully other times
Why One plan for multiple queries
© 2013 SQL Sentry, Inc. All rights reserved.