@Lynn, you realize I was only kidding with this right :w00t:

Now back on topic......

Ninja's_RGR'us (8/11/2011)

---

Tom.Thomson (8/11/2011)

---

But which is crazier there - the locking hint or the tortuous where clause (getting rid of...

Tom.Thomson (8/11/2011)

---

But which is crazier there - the locking hint or the tortuous where clause (getting rid of all...

dheeraj gupta (8/11/2011)

---

Thanks for quick response.

Then how to leave specifically for which statistics has been updated while rebuild the table indexes and update the stats for rest of the things?

Need...

SQLHeap (8/11/2011)

---

GilaMonster (8/11/2011)

---

Add ID as a 3rd key column to this index:

CREATE NONCLUSTERED INDEX [N2] ON [dbo].table

(

field_name2 ASC,

...

Evil Kraig F (8/11/2011)

---

Out of curiousity, why not include the ID instead of key it? Would reduce the tree...

Am I better off proving this is a bug in 2008...

Tx, I had forgotten about that one (1 call ever, 6...

where >= DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) AND <= GETDATE()

for midnight next date, just put 1 instead of the 1 0 and then use < instead of <=

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790:...

99% sure it's a bug in MS now.

I tried a lot of combos, new vms, new hardware, shrunk the log file, added a new log file, created a new blank...

If you need help there I can refformat that whole proc in 10 seconds for you... just let me know.

Do you still need help with this problem (tuning wise)?

Thanks for the update. And with the extra index?

BTW, if you don't post the actual execution plan we're just guessing at this... which we don't like to do ;-).

From that info, the server likely has to scan the whole table.

Include the id you need to select in the N2 index (included column). as the third key.

Edited brain...

I'm guessing this is a local db on a slow disk subsystem so if you have GBs of data to read then yes this will take a long time.

Without seeing...