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: September 2016

what is our options for improvoing

omranabd 2016-09-28 1

Read More

how to improve the query

omranabd 2016-09-28 1

Read More

would like to tune the query

saptek9 2016-09-27 1

Read More

would like to do query tuning for this stored procedure

saptek9 2016-09-27 2

Read More

would like to improve the query

saptek9 2016-09-26 1

Read More

Is SQL Server secretly using unused indexes?

Greg S 2016-09-21 7 1

Read More

New to SQL Sentry – possible to find a specific sql statement?

jjones64 2016-09-21 4

Read More

Its my first time, any suggestions for diagnosing this plan?

SQLTweaker 2016-09-21 1 1

Read More

Incorrect Actual Rows and other issues

Vlady Oselsky 2016-09-19

Read More

Can't find a self-join causing 227M seeks

William Meitzen 2016-09-19 4 4

Read More

How can this query show > 10M reads?

gbritton 2016-09-19 1 1

Read More

Remote Query Execution versus Local Query Execution

GEORGEJO 2016-09-19 1 1

Read More

High number of estimated rows

N 2016-09-19 5

Read More

Can PE post results as they occur?

gbritton 2016-09-19 9

Read More

Query optimizer is doing index scan instead of seek

N 2016-09-19 7

Read More

Clicked stop on a long running query but no sign of stopping

gbritton 2016-09-16

Read More

Query finishes in SSMS not in PE

gbritton 2016-09-16 7

Read More

Trying to research this to see what caused the deadlock

dyard12 2016-09-15

Read More

Two Ideas: Line numbers and remember position

gbritton 2016-09-15 1 1

Read More

Statements show plans that correspond to different statments

Vlady Oselsky 2016-09-15

Read More

Selected text unselected after Get Estimated Plan

gbritton 2016-09-15

Read More

Alt-mouse select doesn't work as expected

gbritton 2016-09-15

Read More

alt-select doesn't work properly

gbritton 2016-09-15

Read More

query consuming more io and CPU

VINOD 2016-09-15 2 2

Read More

END CATCH appears on two lines in the Results

gbritton 2016-09-14 2

Read More

Nested block comments in SQL not displayed correctly

gbritton 2016-09-14 2

Read More

Statistics problem?

Alain Martin 2016-09-14 1

Read More

Where does the Cardinality Estimate go wrong?

Loz 2016-09-13 3 1

Read More

review and decide what are the necessary indices that are missing

Ilias Pazas 2016-09-13 1

Read More

What is the appropriate Index defnition to get rid of the sort operation?

dgate 2016-09-12 2 1

Read More

how do I bring up the histogram statistics

r_prakaash 2016-09-12 5 1

Read More

Plan indicates 917 records inserted. checking the table no records inserted. Why would this be??

GDS 2016-09-08 1

Read More

Index Analysis never completes

gbritton 2016-09-08 14 2

Read More

How do I get this query to finish and not peg my CPUs?

Sean Perkins 2016-09-01 1 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.