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 x539
plan explorer upload x358
poor performance x93
sql server x16
asked: Dec 07, 2016 at 01:56 PM
Seen: 548 times
Last Updated: Jan 08 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
This needs to use less CPU
© 2013 SQL Sentry, Inc. All rights reserved.