If an index is used: http://blog.sqlauthority.com/2008/10/03/sql-server-2008-find-if-index-is-being-used-in-database/

You can tell, but restarts will clear your stats.

There's also a good piece from Kimberly Tripp on duplicate indexes that's worth reading.

FWIW, I'd make sure...

there are a few links here to help you, but let me ask you this. How would you do this without SQL? What is the algorithm you'd use?

Once you have...

I'd do as Lutz suggested.

As a side note, never commit changes in the Table Designer. It makes it easy to change things, add indexes, set primary keys, etc, and I...

rodjkidd (4/17/2014)

---

Greg Edwards-268690 (4/16/2014)

---

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no...

WayneS (4/16/2014)

---

Steve Jones - SSC Editor (4/16/2014)

---

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and...

Divine Flame (4/17/2014)

---

Steve\Gail,

I have written something on it. I may submit it today. You can check if it is good to publish.

P.S.: Like everybody else on SSC, I would always...

OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and no speaking commitments in the future.

😀

Ed Wagner (4/14/2014)

---

I know there are many crazy stories about the weather from this year all over the world, but I have to share today's crazy forecast.

In Michigan, we're at...

That's fine. I know you're good for it.

Sometime.

Not just a query. I'm looking for an article. Imagine that you need to audit permissions and check for all permissions for a user with this new SQL Server 2014...

Thanks, I didn't think we were vulnerable, but hadn't checked.

Not sure we want to move the entire site to SSL, though I understand what you mean here, but perhaps moving...

Thanks, Tracy

yes

Thanks

Eric M Russell (4/11/2014)

---

Obviously the government, whether it be Congress or some agency dedicated to the task, can't come up with the standards; it has to be the industry putting...