Answers.SQLPerformance.com - Archive

Is there anything I can do to improve the overall duration of this merge statement?

GokhanVarol 2013-05-31 12 2

Read More

Having trouble balancing row counts of the threads

GokhanVarol 2013-05-28 2 1

Read More

Why doesn't Query optimizer eliminate unneeded left join in view with Pivot?

mjswart 2013-05-28 5 2

Read More

I want to optimize this query execution to improve its duration.

SQL DBA 2013-05-28 2 1

Read More

It works but not sure how does it work

GokhanVarol 2013-05-24 5 1

Read More

Comparing tables and creating column level difference, can it be better.

GokhanVarol 2013-05-23 2 1

Read More

How does SS determine JOIN operator row estimates

Dan Holmes 2013-05-22 2 1

Read More

This query runs for almost an entire week

Howard 2013-05-20 4 1

Read More

Sort row count estimate different from the row count of its source

Dan Holmes 2013-05-16 1

Read More

Really bad performing query with fulltext

Barry 2013-05-15 1

Read More

This query is very slow. I am new to spatial indexes and am not sure where to begin tuning this query.

jmalley84 2013-05-14 1 3

Read More

Doing quite a bit calculations in a single step, is there a better way?

GokhanVarol 2013-05-12 3

Read More

Plan 2 of 2; Would like some ideas for improving the performance of this query.

Ernest 2013-05-09 1

Read More

Plan 1 of 2; Would like some ideas for improving the performance of this query.

Ernest 2013-05-09 1

Read More

Right most node has the wrong estimate

Dan Holmes 2013-05-08 6 1

Read More

Lazy spool

Jonesboy21 2013-05-07 1

Read More

Can anybody think of a way to optimise the Sorts in the plan attached?

Andy 2013-05-07 1

Read More

Why such a slow query(the main table contains about 1300 KB rows)

Victor.Pozhitkov 2013-05-05 1 1

Read More