Someone can cover for me here... need to go!

http://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx

Called in help.

Repair garantees you'll lose data.

Do you have access to a full backup and all the tlogs backups?

This could be repairable without data loss that way.

Why do you want to lose data (repair mostly deletes stuff!)?

What does this return?

DBCC CHECKDB ('dbName') WITH ALL_ERRORMSGS, NO_INFOMSGS

Ah that makes...

Evil Kraig F (11/15/2011)

---

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

---

I only have 1 more idea aside from what the article say.

Change between to >= AND <=

+ recompile

If that doesn't do it you'll have to...

Revenant (11/15/2011)

---

Actually, entering 50 seconds is three clicks: 5 + 0 + Start. Saves one click, wastes 10...

Evil Kraig F (11/15/2011)

---

Remi, Filtered Indexes run on a similar component to the partition choices of what indexes to use, aligned or non-aligned, as far as I know.

If the query...

You have an unmatched index warning (SSMS Denali).

http://technet.microsoft.com/en-us/library/cc280372.aspx

I haven't read the whole thing but this seems right on target.

Uploaded .sqlplan

Can you post the actual execution plan?

It's 2 clicks, instead of 2 clicks. Obvious 😀

And, again, option recompile doesn't use the index???

What industry are you in?

Stefan Krzywicki (11/15/2011)

---

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

---

Stefan Krzywicki (11/15/2011)

---

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

---

Stefan Krzywicki (11/15/2011)

---

Spent awhile today unable to do anything on a server connected through a Remote Desktop. Everything was fine when I used my...

Stefan Krzywicki (11/15/2011)

---

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

---

Stefan Krzywicki (11/15/2011)

---

Spent awhile today unable to do anything on a server connected through a Remote Desktop. Everything was fine when I used my machine, but if...