Answers.SQLPerformance.com

What’s wrong with 2014’s Cardinality Estimate here?

mjswart 2018-08-17 7 2

identical plans different performance

Pearljammer1 2018-08-14 1

DISTINCT clause degrading performance

NPS 2018-07-17 1

Why such poor performance from same query in different databases

PCF927 2018-07-15 1

Business objects query with EXCEPT runs slow

mylifeandsql 2018-06-26 1 2

How to fix this deadlock? need suggestions.

Maahi 2018-06-12 6 1

I have fixed all the implicit conversion issues, but this query is still too slow

RichardBrianSmith 2018-06-11

How to fix Tempdb spill warning and reduce the long running query timing?

Anamikha1 2018-06-08 3 3

Need help in optimizing the plan

Anamikha 2018-06-08 1

Changing the primary key from non-clustered to clustered on tables causing drop in Join performance

deadliftpro 2018-05-25 5 2

Changing the primary key from non-clustered to clustered on tables causing drop in Join performance

wanderer 2018-05-25 1

How to resolve this deadlock?

Maahi 2018-05-22 2 1

Costly Joins, recommendeations needed on inherited system

ryan.branstetter 2018-05-16 1

Optimizer choosing correct Constant Scan operation only after adding OPTION (RECOMPILE)

Radu Gheorghiu 2018-05-15 1

Bad Query Plan after SQL Server Upgrade

dataczar 2018-05-15 5 1

Why does a 0 rows returned Index Seek cause a 1132 page reads?

Radu Gheorghiu 2018-05-10 2 1

Covering index chooses not to seek

jve 2018-05-07 2

how to speed it up?

doutman 2018-04-27 2

how to minimize the cost for key lookups

doutman 2018-04-26 1

Register for Pro

Sandhya 2018-04-24 1

Any ideas to increase performance of this query?

Cristiano 2018-04-20 1

why is this too lsow ?

doutman 2018-04-20 2

Why does a query inside a IF EXISTS statement not perform the same as outside

tbrickle 2018-04-19 1 2

Why does the same query inside a IF EXISTS statement not perform the same.

tbrickle 2018-04-19 3 1

This query is taking over 2 minutes to run. Please help

Gary Singh 2018-04-19 2

Help to optimise stored procedure

Hibbo 2018-04-16 2

Need help to optimize this plan

Anamikha 2018-04-11 1

upload execution plan

dhart 2018-03-02 1

How to use SQL Sentry Plan Explorer Result filters

deroby 2018-02-27 2

Query makes the application respond with request timeout

Hans 2018-02-27 1 2

What indexes should I add to odsstaging to improve the performance of this query

NickF 2018-02-19 1

How to decrease the cost for Index Seek Operation

SaiKarthik Chandra 2018-02-16 1

Query taking to long to run –

Jayce72 2018-02-12 1

Avoid Keylookups without covering index

VenkatGajjela 2018-02-11 1 1

Test select realtimedr0_.real_time_driveby_

Faruk 2018-02-10

CPU Spike Randomly due to SQL queries

Manav 2018-02-09 2

IS POSIBLE OPTIMIZE VELOCITY?

JERSAN 2018-01-28 1

I CAN OPTIMIZE PERFORMANCE?

JERSAN 2018-01-28 1

How can one turn an index scan into a seek?

MaricopaJoe 2018-01-16 2

Why does an index scan read more pages than exist in an index?

Radu Gheorghiu 2018-01-12 5 1

totaly wrong plan

Alexk 2018-01-07 1

SQL server choosing wrong index to run this query

mauripop 2018-01-04 3 2

How to get predicate push down in WITH statements

Tony Green 2017-12-28 2 1

Tableau Server vs Desktop

kosmik5 2017-12-27

Query tuning guidance

Maahi 2017-12-27 4 1

DISTINCT OPERATOR

Maahi 2017-12-21 8 1

query plan suggestions

Maahi 2017-12-21 1 1

sort performance in query plan

Maahi 2017-12-21 9 2

Additional Tuning Opportunities

DBNewbie_2007 2017-12-21 2 1

SQL Plan Explorer Missing Execution Mode

DBNewbie_2007 2017-12-21 5 2

Clock Time is over 2 minutes, but Duration is .684 at end?

Gemini_X 2017-12-21 1 2

Query is taking 1.5 hours

KTD 2017-12-20 1 1

Not sure what's wrong with my query

Sipho Mhlanga 2017-12-20 2

Why is this query causing the execution plan to include tables NOT in the query itself?

Rob@MMIT 2017-12-19 3 1

Improve the query performance

Arvind 2017-12-18 3

Plan Explorer and SQL 2000

Jeff 2017-12-14 1

Can I safely deactivate Trace Flag 4136?

JonasWanninger 2017-12-14 2 2

Not a question, just curious if anyone has seen anything this bad

Craig Mac 2017-12-12 1

who am i please answer

Viv 2017-12-12

How to minimize High Residual IO

mauripop 2017-12-09 1 2

How to protect a database from the Server Administrator in Sql Server

kosmik5 2017-12-06

Need suggestions on reducing execution time of sp

Maahi 2017-12-05 2 2

Having problems understanding what what can be improved

Alex shaw 2017-11-30 1

Slow Procedure

sstrauss 2017-11-30 2

update times seem to be very slow based on what is being updated

Fanz 2017-11-29 1 1

Sudden slowdown of inline code on 2014, fast with old CE, but can't change.

mbourgon 2017-11-28 1

Stock query – CPU usage – SentryOne

firasatahmed 2017-11-27 1 1

Usage of three index for the same table

Thomas Franz 2017-11-27

takes 28 seconds to run to produce 299 rows

gmdatdev 2017-11-27 1

I am being told that this process use to complete in 6 to 9 seconds, now it is taking over an hour!

TomHSQL 2017-11-16 1

Please help with these merge joins

NYdmx123 2017-11-15 5 2

I need help to improve the performance of this view

Amey 2017-11-13 1

How to improve this procedure (Part 2)

MikeS 2017-11-13

I'm tasked with making this query run under 4 seconds

jrb2971 2017-11-08 2 2

How to improve this procedure??

MikeS 2017-11-08 2 2

How to improve the performance of this query where 5 varchar(max) columns are in the SELECT list with only table join to filter out the records based on PK column.

uravireddy 2017-11-06 1 2

I've inherited a server/application. This query seems to be my biggest problem child.

Steve Malcolm 2017-11-02 1

How to remove waits and modify primary index?

opd_dba 2017-10-30 1

to get rid of key lookups, do I add all the where clause columns to covered index or just create a new index on its own. Which one is better or best practised then the others

Arsh 2017-10-30 1

What are these warning errors telling me and how do I resolve the issue

cfajuke 2017-10-30 1

SQL timeout

Aravindan 2017-10-27 2 2

Sort or No sort before merge join depending on order columns in join condition

Wilfried 2017-10-23

Why a sort after merge join

Wilfried 2017-10-20

How can I reduce the cost of hash match?

Marekx371 2017-10-19 7 1

Trying to speed up this 'GetWorkingDays' function.

Jason A Long 2017-10-18 1

Analysis Services Query/Command using most memory

Ken 2017-10-17 2 2

Cant elimintated these Index Scan

Marekx371 2017-10-16 1

which city was you born

opd_dba 2017-10-16

Distinct sort issue

Arvind 2017-10-16 1

How can eliminate these two sort that are very expensive ? and reduce cost on index seek

Marekx371 2017-10-12 2 2

looking at execution plan the actual number of rows is lot smaller than estimated row and i updated all my statistics and i still see slow performance to select 372 rows any suggestion

TheGunners 2017-10-12 2 2

How can I get the estimated rows closer to the actual?

ssharpxzyv87 2017-10-11 1

Ideas as how I might increase effeciency yet retain the same results?

DataBASS 2017-10-10 1

xml input to a SP results in a useless Plan

mauripop 2017-10-10

How should i optimize this query

ErikU 2017-10-06 1

How can i remove these table scans ?

Marekx371 2017-10-05 1

UGH EF query

tcstl 2017-10-05

I have a query that produces a good plan and a bad plan

Erickson Winter 2017-10-04

I have a query that produces a good plan and a bad plan

Erickson Winter 2017-10-04 1

Are the inserts really what is causing this query to go slow?

JoeyC 2017-10-04