Easiest test is to script them, drop 'em all and see how much and if it helped.

I still feel there's a bigger issue here.

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 I tried to...

I think you'd be better off starting a new thread with replication getting 1 hour behind as the title.

You'll get better help that way to solve your real issue ;-).

Usually...

aurato (11/15/2011)

---

jared-709193 (11/15/2011)

---

Now we understand your real concern. You don't want indexes there that are unused because you feel that it may affect performance. Let me ask you...

I don't mean to be snippy and that's not my intention.

I guess I'm too tired. Logging off.

Time to see for yourself what we see in your situation.

Got 3 hours?

http://www.youtube.com/watch?v=Kcnj5bQghjY&feature=relmfu

http://www.youtube.com/watch?v=XmE_Utp8CY0

http://www.youtube.com/watch?v=RZ4YTg4S7HI&feature=relmfu

Don't be fooled by the title. They are all equally important and useful.

You've clearly made up your mind, even before coming here.

So...

P.S. Check out those survey results...

9 index is "nothing"

http://sqlskills.com/BLOGS/PAUL/post/Survey-nonclustered-index-counts-(code-to-run).aspx

If you need the new index then you need the new index.

Short of massive space shortage I wouldn't start with "what index can I drop?".

I would start with is there...

Nothing wrong with daydreaming & littel distractions. I can't really imagine a sci-fi author NOT being...

I can't make that call for you. ...

How about step #1 we try to bring that down under 10 sec?

Can you post the actual execution plan?

Brandie Tarvin (11/15/2011)

---

SQLRNNR (11/15/2011)

---

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

---

Brandie Tarvin (11/15/2011)

---

EDIT: Nevermind. I see you were quoting them...

GSquared (11/15/2011)

---

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

---

Brandie Tarvin (11/15/2011)

---

EDIT: Nevermind. I see you were quoting them for Grant....

aurato (11/15/2011)

---

I'm trying to figure out what a system process would want with it. If it's something like a consistency check then it's usage that isn't important because it...