Jeff Moden (6/20/2014)

---

I don't know exactly what you're going for but the following article may provide some food for thought in the area of generating test data, specifically where dates...

I'll try to illustrate what I am trying to do.

If I were to run this test today. I would would want it to pull records from my template records to...

Yes I think you are right. Once I killed the mirroring the backup was < 4GB which is about right. Now I just need to reestablish mirroring and I am...

I think I see the problem. This is a mirrored database. The mirror is suspended and I can't restart it. I assume the databases have fallen too far out of...

No luck. The table does have two non-clustered indexes and on clustered. Rebuilding the clustered index seems to have no effect. The odd part is that when I start the...

No, not yet. This sounds very very plausible. I just rebuilt the clustered index. Trying another copy-only backup.

Thanks,

I can agree with...

Lynn Pettis (6/26/2012)

---

Maintenabce plans are good for small databases or when you find yourself an Accidental DBA having to get something into place. I used them when I first...

Thanks all, I will backup the model as well since it seems like it won't hurt. I will handle that backup manually since we are not modifying it. If I...

Thanks for the advice. Believe me I never what to shrink again, and hopefully with proper management I never have to. I needed to shrink because I had an outrageous...

So incredibly happy right now. The index rebuild on the two indexes for the table (one clustered and one non) finished, and the total size of the table is now...

Still running at this point, but interesting development. It looks like the database outgrew its current allocation and took in another 10GB from the file system. This is also confirmed...

One other odd thing, and maybe it has to do with sp_spaceused. I noticed that the row number wasn't dropping. There was no progress at all. I tried to stop...

I am running Microsoft SQL Server 2005 - 9.00.5000.00 Workgroup

Regardless, I took a look for the ghost process, and one is running. The ghost records are little over my head...

The table in question is does have a primary key/clustered index.

As for the ROWCOUNT, noted. There are various resources that say how one should limit the amount of work done...