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: July 2015

Why do logical reads and scan count increase with the addition of the where clause

Tony Green 2015-07-31 4 2

Read More

This seems to be taking over 5 hours

RichardBrianSmith 2015-07-30 1

Read More

Query performance – hash match

thenewbee 2015-07-29 4 1

Read More

Why is there a scan on Orders instead of a seek?

Mark Freeman 2015-07-29 1 2

Read More

How long is too long for a SELECT compile?

Dan Holmes 2015-07-27 1

Read More

Multi-threaded inserts vs serial

runamuk0@msn.com 2015-07-25

Read More

How can I forceseek?

systemr 2015-07-23 1 1

Read More

Query plan shows index seek on table not referenced in the query anywhere

Yaraj 2015-07-22 1 1

Read More

The query takes a long time to run, looking for options to try and get it to run faster based on this plan?

sap4ora 2015-07-21 1

Read More

No perceived improvement even after adding index

Yaraj 2015-07-20 3 1

Read More

Statistics Issues

Ashley Theobald 2015-07-17 2 1

Read More

I need to optimize the query ,any suggestion s is welcome

MiltonF 2015-07-15 1

Read More

merge join with remote table takes 1 hour

ob123 2015-07-11

Read More

Unexecuted statement in a proc causes significant perf change

Dan Holmes 2015-07-09 2

Read More

Improve plan_

jolaSQLDBA 2015-07-06 3 1

Read More

How to replace cursor for performance

Felix 2015-07-06 1

Read More

Index not being used

Peachy 2015-07-01 3 2

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.