active newest hottest most voted
All questions
0
votes
1
answers
11
views

TOP 1 running very slow vs TOP 2 or more running fast

11 hours ago Aaron Bertrand ♦ 1.3k
1
votes
1
answers
102
views

Which One Would You Choose

yesterday SQLkiwi ♦ 5.5k
0
votes
0
answers
30
views

Estimated row count vs actual row count

yesterday Jmann84 1
0
votes
1
answers
10
views

Querying sql 2000 using values from previous rows

3 days ago RichardBrianSmith 67
0
votes
1
answers
36
views

Where do i find the 'throw out the not needed table' in the plan

6 days ago GregGonzalez ♦♦ 81
0
votes
0
answers
42
views

Why is a join with a table variable causing a missing join column on the nested loop?

6 days ago kudz 0
0
votes
1
answers
22
views

Optimizer gets the wrong number of estimated rows even with updated stats

6 days ago SQLkiwi ♦ 5.5k
0
votes
1
answers
224
views

Old SQL and New Hardware X All New

Mar 10 at 01:24 AM Aaron Bertrand ♦ 1.3k
0
votes
1
answers
14
views

Reads in statement tree differ from Table I/O Reads

Mar 10 at 01:22 AM Aaron Bertrand ♦ 1.3k
0
votes
1
answers
18
views

Avoiding hash Match by using covering index on object2.index2

Mar 05 at 06:35 PM RichardBrianSmith 67
-2
votes
1
answers
64
views

Why over 1.3TB desired memory for this query?

Feb 27 at 04:57 AM SQLkiwi ♦ 5.5k
0
votes
2
answers
16
views

The amount of rows flowing into the nested loop join

Feb 26 at 11:27 AM SQLkiwi ♦ 5.5k
0
votes
1
answers
28
views

Deadlock - I do not understand the lock sequence. Are these table-locks or index-locks??

Feb 25 at 10:30 PM SDyckes2 66
1
votes
1
answers
18
views

What are the minimal rights needed to see the Wait Stats tab in Plan Explorer Pro?

Feb 25 at 01:35 PM Calvin Jones 16
0
votes
1
answers
38
views

Lazy Spool causes the slow query

Feb 23 at 11:17 PM Kai 1

1 2 3 4 5 ... 35 next page »

posts per page 15 30 50