That only occurs when a restore is run. It has to occur because after a database is restored, there is no way that SQL Server can be assured that...

No, don't create more files. The issue is the code and the indexes. That is almost always the issue. You can only temporarily solve most problems by throwing more hardware...

It could simply be a bitch session, but then again, a valued employee might have some valid issues that the company could address. Taking myself as an example, I'm, less...

I don't think so, no. The problem is, I'm having a hard time understanding the issue. If you want unique data.... you have to make the data unique. You can't...

Another person to contact is your local Microsoft... what's the word, it's not advocate, but somethign like that. Anyway, I'm not sure who yours is for your region. It might...

Lynn Pettis (4/29/2010)

---

dbowlin (4/29/2010)

---

Thanks Grant, this is helpful.

Someone on LinkedIn referred me to Blythe a little earlier today. I sent her an email asking for details.

I am curious about...

dbowlin (4/29/2010)

---

Thanks Grant, this is helpful.

Someone on LinkedIn referred me to Blythe a little earlier today. I sent her an email asking for details.

I am curious about the number...

Ah, a 100gb log is a VERY far cry from a 100tb log, and makes one heck of a lot more sense.

Personally, I was only ever managing 700gb and that...

Carl B. (4/29/2010)

---

Yes, I am sure it's not a REORG it's a REBUILD of the indexes.

We noticed that behavior two times.

Now that we have changed the schedule of these...

Oooh, good catch. That's entirely possible.

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...