Then perharps newb ol?

:w00t:

Ok guys, IT DEPENDS. Now go test on your queries and stop beating this to death.

Tho 0.3% looks like a good starting figure :hehe:.

1 - SELECT * FROM table where Column IS NULL

2 - Are you using left joins? That could cause the same issue.

Looks more closely, maybe 1 column is out of order, maybe the include is different. It doesn't take much to get an extra recommendation even if it makes no...

Steve Jones - SSC Editor (4/5/2011)

---

David McKinney (4/5/2011)

---

Hi Steve,

I agree with you on the overall. However, I didn't quite understand your specific reference to the "brilliant" duplicate indexes...

Then the select is the problem unless you have some sort of bug in your video card.

I have noticed a slow down when showing plans, but showing only 1-2 plans...

Depends on the clustered index of the base table. If the first column is identity of getdate() you'll get very little fragmentation.

However if you're pk is anything else like...

http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

Jeff Moden (4/5/2011)

---

Have...

Jeff Moden (4/5/2011)

---

Have...

Got any function call or rbar or while loops in the code anywhere (could be triggers)?

How can a heap be fragmented? We ask sql server to NOT keep any particular order, so it does just that.

You can't have no index and then complain that...

Cool, I just hope he understands the code before using it in prod.

I'm 99.999999999999% sure it can be done. The missing decimal is that I don't have the data in front of me. It looks like denormalized table, so using...

How up to date are your stats???

Index fragmentation?

Those 2 could also cause this problem if the table is big enough.