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: May 2014

Tuning the query

DBA99 2014-05-30 1

Read More

Biggest question is why there is so much difference between the estimated rows and the actual rows for temp tables

Mac 2014-05-29 5

Read More

How to remove Hash Match Inner Join and Index Scan to Index Seek?

Guru 2014-05-20 3 2

Read More

Plan IO vs Reads in profiler

Ranga 2014-05-20 7 1

Read More

how to do suffix search on full text indexed table

anandcse17 2014-05-20 2 1

Read More

way to improve the nested lookups? or is should I be looking elsewhere

Joe_Hell 2014-05-19 2 1

Read More

Query slow after adding additional where clause

Alan 2014-05-19 12 2

Read More

What is the best way to remove key lookup (costing 68%) ?

Kin 2014-05-17 4 2

Read More

I am looking for a sql server 2012 tutorial

vandykish 2014-05-16 1 3

Read More

How can I move the select statement TOP 1 out and into a join?

victoryismine06 2014-05-16 2 1

Read More

TOP used before the predicate – feels like a Sql bug but certainly i am missing something

Dan Holmes 2014-05-14 5 1

Read More

Query Rewrite

DDKG 2014-05-14 5 2

Read More

merge join operator estimations

NEERAJ PRASAD SHARMA 2014-05-14 3 1

Read More

Why dont I see execution plan sometime using exec Query Plan

PRO 2014-05-13 2

Read More

100 Percent CPU Race condition

GW 2014-05-13 17 2

Read More

Unexpected sort operation

GANGA_dba 2014-05-12 2 2

Read More

Filling in the gaps: there has to be a better way

Dan Holmes 2014-05-09 6 1

Read More

how to change the timeout setting when getting an estimated plan

Dan Holmes 2014-05-09

Read More

Query Rewrite. How to rewrite the SQL Query to avoid multiple Nested Loops – Left Outer Join

DDKG 2014-05-02 7 2

Read More

Indexing Advice required

PRO 2014-05-01 1 4

Read More

Performance doesn't change even move the where condition statement to JOIN

Guru 2014-05-01 1 1

Read More

slow run on query when is joined with another view

robertdsgt 2014-05-01 1 2

Read More

Interesting Performance problem

Gaurav 2014-05-01 13 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.