Jeff Moden based on what ScottPletcher stated I do not see how one would end up with 2 Indexes as he did state you Drop one of the Indexes...

You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

I've started on code to do this...

Bump post to get my message to show up because it's the first post on a new page. 🙁

@steve-2 :

I guess my question would be, what are the marketing stats for the site?  Perhaps a bit of understanding there would help us shape our requests...

As for scripts to "find duplicates", they have this new fangled thing called a "search engine". 😀

Try the following search and see what you come up with.  I haven't looked...

You don't actually have to drop both indexes.  You would, for example, often drop one index and modify the other one.

I've started on code to do this process but...

You don't.  You have to drop both indexes and create...

Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.

I don't know what I can say or do and I'm fairly frustrated...

Heh... GETDATE(). 😀

Back, barely functional after a few airplanes, but I see your complaints and have forwarded them on.

I don't know what I can say or do and I'm fairly frustrated...

And, just to assure you this type of thing does work exactly as I've stated (and I'm sure that Eric would agree), I have a 2005 database that...

I think that the people who made the decision to move to to the cloud should have the sole responsibility of monitoring the costs to prevent all the...

I've got something I'm not aware of performing backups of my dbs at random times in the day. I think it is performing backups however it says 0 pages...

I think that maybe the HammerDB code you ran in the other thread is a better tell.

Dear Steve Jones...

I forget how long it's been since this site was moved to WordPress but it's been a long time.  Those of us long-timers that are left...