That's called a maintenance plan.

Backup, test the backups.

Keep the backups as long as necessary.

Shit happens, you can <mostly> prepare to repair the damage.

Change control management is an extra protection on...

Which is the only reason I suggested the check of fragmentation. Assuming you...

And as I...

This guy was the perfect <shit> storm of bad mannerism and even worst advice with a <avalanche> hint of God complex.

That sums it up pretty good :-D.

Try 100%.

See how long it takes for that table (if ever) to get picked up by a smart defrag script like this one : http://sqlfool.com/2011/06/index-defrag-script-v4-1

Then see if it's smart to...

GSquared (11/17/2011)

---

Oh trust me, I've had my goof-up posts. Gail and Paul are the ones who catch me on it now and again. Those two are a good...

And you can see that even months later, it still strikes a cord with many of us :hehe:.

For what index on that table?

So you NEVER, NEVER, EVER have updates once the insert in done?

Dev (11/17/2011)

---

Sean Lange (11/17/2011)

---

Dev (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

Tom Brown (11/17/2011)

---

It has to be oversized, have you seen his list of qualifications - not sure I understand most...

The op was giving extremelly bad advance (edit like my speeling ATM). Dangerous to the point that you could lose a DB and your job if you followed it.

He...

Brandie Tarvin (11/17/2011)

---

p-nut (11/17/2011)

---

Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave open...

I've always had this in mind.

If you realllllly don't care about the data then why do you bother with it? You save it, you maintain it, you look at...

p-nut (11/17/2011)

---

Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave open transactions. ...

Tom Brown (11/17/2011)

---

Ah ha

No offence intended GS 😉

But I see you have deleted yours quals list Ninja (if you ever joined that game) - I'm sure you would be...

Ninja's_RGR'us (11/17/2011)

---

I'm so glad you qualified what covered that much ground. I had a totally different picture in my head at first...