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 x676
plan explorer upload x489
poor performance x115
sql server x23
asked: Dec 07, 2016 at 01:56 PM
Seen: 641 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
What indexes should I add to odsstaging to improve the performance of this query
this query timeout many times and runs successfully other times
© 2013 SQL Sentry, Inc. All rights reserved.