Answers.SQLPerformance.com - Archive

How can I avoid this bad plan

Chris Wilson 2014-07-31 7 3

Read More

Can you suggest what can be done to improce my query

Arun 2014-07-30 1

Read More

Why Does the First Plan run much faster than the second?

mike1142 2014-07-29 5 2

Read More

Need Help with this plan ( Query is running more than 1 Hour)

SQLFanatic 2014-07-29 2 1

Read More

Table in exec plan but not in STATISTICS IO results

Srdjan Milakovic 2014-07-23 6 2

Read More

Can anybody advise on how to remove the key lookup costing 48.1%

Pearljammer1 2014-07-23 1 2

Read More

How do I create a index to increase the performance on Key Lookup

Eduardo 2014-07-21 1

Read More

Why is query going parallel?

SQL_JGood 2014-07-17 5 2

Read More

SQL is ignoring my index hint and using a clustered index.

DaliMorse 2014-07-15 9 1

Read More

Bad Estimated I/O Cost

Juan Burgos(ARG) 2014-07-11

Read More

The query is taking 20 mintues to run. It's a view -which has a select statments

sqlmega 2014-07-11 2 3

Read More

Why does Statement1 taking 30% more (in duration) than Statement2; clearly cpu & reads are smaller?

SQL_DV 2014-07-10 3 2

Read More

whats going wrong here – query taking too much time to return result

Rsys dba 2014-07-07 1

Read More

Slow Query

Dekaeron 2014-07-01 1 1

Read More

Can I get the query to use an Index Seek instead of Clustered Index Scan

Howard Diesel 2014-07-01 5 1

Read More