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 x527
plan explorer upload x343
poor performance x91
sql server x16
asked: Dec 07, 2016 at 01:56 PM
Seen: 543 times
Last Updated: Jan 08 at 05:06 PM
Help with query optimization
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
How can I further optimise this query?
© 2013 SQL Sentry, Inc. All rights reserved.