SQLPerformance.com by SentryOne
The Answers.SQLPerformance.com Q & A site has been made read only. Read about the process.
Please visit our support site to ask new query tuning or Plan Explorer questions.

Home | Month: April 2015

How to avoid Table Spool and Hash Match.

Birr 2015-04-23 1 2

Read More

Can comparing a nvarchar column to a varchar in the join cause duplicate rows in the result set?

TomI 2015-04-23 1 1

Read More

Insert taking long time

Arvind 2015-04-23 1 1

Read More

What can I do to help improve the estimates with this query?

g00p3k 2015-04-22 4 2

Read More

Query time outs

Arvind 2015-04-22 1

Read More

Sort operator in Execution plan

VINOD 2015-04-21 1

Read More

Highest priority areas to evaluate for extreme disk latency

g00p3k 2015-04-20 1 1

Read More

The table spool operator costing 32.9% appears to have a massive difference between estimated number of rows and actual number of row. Is this a stats problem ? Do i need to remove this operator ?

Pearljammer1 2015-04-16 1

Read More

filter and aggregate over a 1.5 million records table taking a long time

2033811 2015-04-09 5 1

Read More

A filter with the attached query causing slowness and performance issues

SQLDB 2015-04-09 3 1

Read More

Query running slow

Arvind 2015-04-09 1 1

Read More

SSAS and SQL Engine Memory

Sam 2015-04-08 1 1

Read More

Why is the merge join in Node 48 [lowest right Inner Join] estimating a loss of 20% of the rows?

Kunkel 2015-04-07 13 1

Read More

This query is causing lock escalation ( 6000 to 8000 locks) Any idea on how to tune it to minimze the locks ?

Sam 2015-04-03 2 1

Read More

How to reconcile the cumulative duration to the sum of the pieces

Dan Holmes 2015-04-02 3 1

Read More

Any idees how to get better performance for this query, it's a vendor app I cant change the query just indexes, statistics and plan guide.

Hans 2015-04-01 1 1

Read More

Slow Query – Incorrect Estimated Executions?

ijabit 2015-04-01 8 1

Read More

To much estimated rows

LukaszTerlecki 2015-04-01 2 1

Read More

How to optimize this plan? Lot of difference between estimated and actual rows.

Max 2015-04-01 1

Read More
SentryOne
Sponsor & Curator
Design and content © 2012-2022 SQL Sentry, LLC.  All rights reserved.  User contributions are licensed under cc-sa with attribution required.