Answers.SQLPerformance.com - Archive

DISTINCT clause degrading performance

NPS 2018-07-17 1

Read More

How can I change the where clause of this sp so it can do the index seek?

PK 2017-02-17 2

Read More

how do I bring up the histogram statistics

r_prakaash 2016-09-12 5 1

Read More

Wrong index scan

Yorik 2015-12-28 8 2

Read More

Query with many joins and subqueries slowing the server if more than one execution concurrently

Juliano 2015-10-05 4

Read More

How to handle more multiple filters(more than 15) in big query

Amit Rohatgi 2014-10-01 1

Read More

New to Plan Explorer. What is the best area to focus on to start?

Jimbo 2014-09-30 1

Read More

I am looking for a sql server 2012 tutorial

vandykish 2014-05-16 1 3

Read More

This query is taking nearly 12 minutes to run

Kaloyan 2013-10-31 1 1

Read More

This plan is generating 96 million reads, anything you can point it that could be improve?

alhedo 2013-10-28 5 3

Read More

Table Insert is given 95% of the estimated cost – why?

Dan Holmes 2013-03-08 5 2

Read More

Capturing Statistics IO information

GokhanVarol 2013-02-28 4 2

Read More

why is the MERGE JOIN passing 4,513,373 records

SQLJarhead 2013-02-13 9 2

Read More