Answers.SQLPerformance.com - Archive

Why does the second query perform so much better than the first, but does more logical reads?

Mark Freeman 2017-05-31 2 2

Read More

Concered with the Est Rows vs Actual Row Count

Tennim 2017-05-29 4

Read More

Is columnstore indexes not a good fit for this for performance for another query

GokhanVarol 2017-05-28 2 2

Read More

Is columnstore indexes not a good fit for this for performance

GokhanVarol 2017-05-28 4 1

Read More

Can someone please recommend a solution for avoiding the clustered index scan on IX_secAssignment_MissionUnit?

jmnsprings 2017-05-27 1

Read More

Please let me know how to optimize this query .

Vinu 2017-05-25 1

Read More

SQL takes 100% of CPU despite low activity of the DB

Liran.E 2017-05-23 2

Read More

Hash join spills to disk even though there is plenty of memory granted for the query

GokhanVarol 2017-05-19 1

Read More

Is there a way to get this to seek in the 2nd query?

John M Couch 2017-05-18 1

Read More

Is this an intra-query parallelism deadlock and how to fix it?

Tony Green 2017-05-18

Read More

how to fix the full table scan and merge join?

jrb2971 2017-05-17 1

Read More

High Columstore index scan cost

JoshisOn 2017-05-17

Read More

how can i get rid of this sort spill

RichardBrianSmith 2017-05-15 1

Read More

What column(s) do I need to include as part of the index creation on Object2 to improve performance

David Beaty 2017-05-15 1 1

Read More

CTEs and ROW_NUMBER revisited

mjswart 2017-05-12 1

Read More

I am concerned about the row estimates

jmalley84 2017-05-08

Read More

Performance Issues

inginheiiro 2017-05-08 1 1

Read More

How can I improve this plan. Table Insert is costing the most at 84.6% – can it be improved ?

Pearljammer1 2017-05-05 2 1

Read More

Optimise help required

Felix Nathan 2017-05-04 1

Read More

Asynchronous AG Log Send Queue Growing then flushing quickly

SystemsSQLAdmin 2017-05-03

Read More