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 | Author: SentryOne

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

mjswart 2018-08-17 7 2

Read More

identical plans different performance

Pearljammer1 2018-08-14 1

Read More

DISTINCT clause degrading performance

NPS 2018-07-17 1

Read More

Why such poor performance from same query in different databases

PCF927 2018-07-15 1

Read More

Business objects query with EXCEPT runs slow

mylifeandsql 2018-06-26 1 2

Read More

How to fix this deadlock? need suggestions.

Maahi 2018-06-12 6 1

Read More

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

RichardBrianSmith 2018-06-11

Read More

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

Anamikha1 2018-06-08 3 3

Read More

Need help in optimizing the plan

Anamikha 2018-06-08 1

Read More

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

deadliftpro 2018-05-25 5 2

Read More

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

wanderer 2018-05-25 1

Read More

How to resolve this deadlock?

Maahi 2018-05-22 2 1

Read More

Costly Joins, recommendeations needed on inherited system

ryan.branstetter 2018-05-16 1

Read More

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

Radu Gheorghiu 2018-05-15 1

Read More

Bad Query Plan after SQL Server Upgrade

dataczar 2018-05-15 5 1

Read More

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

Radu Gheorghiu 2018-05-10 2 1

Read More

Covering index chooses not to seek

jve 2018-05-07 2

Read More

how to speed it up?

doutman 2018-04-27 2

Read More

how to minimize the cost for key lookups

doutman 2018-04-26 1

Read More

Register for Pro

Sandhya 2018-04-24 1

Read More

Any ideas to increase performance of this query?

Cristiano 2018-04-20 1

Read More

why is this too lsow ?

doutman 2018-04-20 2

Read More

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

tbrickle 2018-04-19 1 2

Read More

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

tbrickle 2018-04-19 3 1

Read More

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

Gary Singh 2018-04-19 2

Read More

Help to optimise stored procedure

Hibbo 2018-04-16 2

Read More

Need help to optimize this plan

Anamikha 2018-04-11 1

Read More

upload execution plan

dhart 2018-03-02 1

Read More

How to use SQL Sentry Plan Explorer Result filters

deroby 2018-02-27 2

Read More

Query makes the application respond with request timeout

Hans 2018-02-27 1 2

Read More

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

NickF 2018-02-19 1

Read More

How to decrease the cost for Index Seek Operation

SaiKarthik Chandra 2018-02-16 1

Read More

Query taking to long to run –

Jayce72 2018-02-12 1

Read More

Avoid Keylookups without covering index

VenkatGajjela 2018-02-11 1 1

Read More

Test select realtimedr0_.real_time_driveby_

Faruk 2018-02-10

Read More

CPU Spike Randomly due to SQL queries

Manav 2018-02-09 2

Read More

IS POSIBLE OPTIMIZE VELOCITY?

JERSAN 2018-01-28 1

Read More

I CAN OPTIMIZE PERFORMANCE?

JERSAN 2018-01-28 1

Read More

How can one turn an index scan into a seek?

MaricopaJoe 2018-01-16 2

Read More

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

Radu Gheorghiu 2018-01-12 5 1

Read More

totaly wrong plan

Alexk 2018-01-07 1

Read More

SQL server choosing wrong index to run this query

mauripop 2018-01-04 3 2

Read More

How to get predicate push down in WITH statements

Tony Green 2017-12-28 2 1

Read More

Tableau Server vs Desktop

kosmik5 2017-12-27

Read More

Query tuning guidance

Maahi 2017-12-27 4 1

Read More

DISTINCT OPERATOR

Maahi 2017-12-21 8 1

Read More

query plan suggestions

Maahi 2017-12-21 1 1

Read More

sort performance in query plan

Maahi 2017-12-21 9 2

Read More

Additional Tuning Opportunities

DBNewbie_2007 2017-12-21 2 1

Read More

SQL Plan Explorer Missing Execution Mode

DBNewbie_2007 2017-12-21 5 2

Read More

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

Gemini_X 2017-12-21 1 2

Read More

Query is taking 1.5 hours

KTD 2017-12-20 1 1

Read More

Not sure what's wrong with my query

Sipho Mhlanga 2017-12-20 2

Read More

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

Rob@MMIT 2017-12-19 3 1

Read More

Improve the query performance

Arvind 2017-12-18 3

Read More

Plan Explorer and SQL 2000

Jeff 2017-12-14 1

Read More

Can I safely deactivate Trace Flag 4136?

JonasWanninger 2017-12-14 2 2

Read More

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

Craig Mac 2017-12-12 1

Read More

who am i please answer

Viv 2017-12-12

Read More

How to minimize High Residual IO

mauripop 2017-12-09 1 2

Read More

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

kosmik5 2017-12-06

Read More

Need suggestions on reducing execution time of sp

Maahi 2017-12-05 2 2

Read More

Having problems understanding what what can be improved

Alex shaw 2017-11-30 1

Read More

Slow Procedure

sstrauss 2017-11-30 2

Read More

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

Fanz 2017-11-29 1 1

Read More

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

mbourgon 2017-11-28 1

Read More

Stock query – CPU usage – SentryOne

firasatahmed 2017-11-27 1 1

Read More

Usage of three index for the same table

Thomas Franz 2017-11-27

Read More

takes 28 seconds to run to produce 299 rows

gmdatdev 2017-11-27 1

Read More

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

Read More

Please help with these merge joins

NYdmx123 2017-11-15 5 2

Read More

I need help to improve the performance of this view

Amey 2017-11-13 1

Read More

How to improve this procedure (Part 2)

MikeS 2017-11-13

Read More

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

jrb2971 2017-11-08 2 2

Read More

How to improve this procedure??

MikeS 2017-11-08 2 2

Read More

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

Read More

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

Steve Malcolm 2017-11-02 1

Read More

How to remove waits and modify primary index?

opd_dba 2017-10-30 1

Read More

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

Read More

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

cfajuke 2017-10-30 1

Read More

SQL timeout

Aravindan 2017-10-27 2 2

Read More

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

Wilfried 2017-10-23

Read More

Why a sort after merge join

Wilfried 2017-10-20

Read More

How can I reduce the cost of hash match?

Marekx371 2017-10-19 7 1

Read More

Trying to speed up this 'GetWorkingDays' function.

Jason A Long 2017-10-18 1

Read More

Analysis Services Query/Command using most memory

Ken 2017-10-17 2 2

Read More

Cant elimintated these Index Scan

Marekx371 2017-10-16 1

Read More

which city was you born

opd_dba 2017-10-16

Read More

Distinct sort issue

Arvind 2017-10-16 1

Read More

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

Marekx371 2017-10-12 2 2

Read More

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

Read More

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

ssharpxzyv87 2017-10-11 1

Read More

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

DataBASS 2017-10-10 1

Read More

xml input to a SP results in a useless Plan

mauripop 2017-10-10

Read More

How should i optimize this query

ErikU 2017-10-06 1

Read More

How can i remove these table scans ?

Marekx371 2017-10-05 1

Read More

UGH EF query

tcstl 2017-10-05

Read More

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

Erickson Winter 2017-10-04

Read More

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

Erickson Winter 2017-10-04 1

Read More

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

JoeyC 2017-10-04

Read More

Posts navigation

1 2 … 10 Next
SentryOne
Sponsor & Curator
Design and content © 2012-2021 SQL Sentry, LLC.  All rights reserved.  User contributions are licensed under cc-sa with attribution required.