noeld (4/29/2010)

---

Forget it ... we know the answer is that it is probably in GB .... or who knows if it was...

Then I'm stumped. It doesn't make any sense. To do an index rebuild, a full scan of the data is required and all new statistics based on the full scan...

ankitwaitshere (4/29/2010)

---

Thanks all for the response.

The primary database is a heavily transactional OLTP database for a Shipping-System. Currently, the database is serving 2 major purposes: 1- routine shippping/scanning etc, and...

No, not knowing more, I wouldn't call it a bug. It's probably something to do with statistics after the rebuild, but I'm just a bit surprised by it because an...

Ah I get it. Performance goes down after the indexes are rebuilt and comes back up after the statistics are updated. Got it.

Well, it's hard to say precisely what the...

It has to be unique to add a unique constraint. So you either modify the data to make it unique, or you modify the structure, adding, for example, an identity...

If I understand what you said, statistics updates are taking 12 hours? That's a pretty serious problem. How big is the database in question?

I sure wouldn't recommend triggers as a mechanism for this.

It really depends on what your business needs are. If you have the need for a near real time copy of...

Yeah, rearchitect the storage so that you've got normalized data.

Barring that, look at this approach for delimited lists from Jeff Moden[/url]. It'll help.

I'm not aware of third party SCOM management packs for SQL Server. Microsoft has a management pack for SQL Server. We use it to do most of our SQL Monitoring....

First things first, contact Blythe Morrow (blythe.morrow@sqlpass dot org) at PASS. They have a starter kit and an infrastructure that will get you going. After that, get help. There are...

Ah, so the FULL SCAN did...

izdede (4/29/2010)

---

Yes, that is the problem since the process/task/data collection set is hung in pending I can't even delete it.

In fact, I have tried restarting my machine to no...

Luke L (4/29/2010)

---

Tom.Thomson (4/29/2010)

---

Dave Ballantyne (4/29/2010)

---

You can always mark you share...

Hard to know. Guys like that tend...