If you're deleting that much data (assuming Chris' Dates are ok), you might be better off just rebuilding the table and only import what you want to keep in there.

Sure is, but now you're just giving him more of what he came here for!

Better now to quote him, other than his nickname.

Glad to see I had so much effects on you all :hehe:.

Revenant (11/28/2011)

---

Revenant (11/28/2011)

---

Dowload the RTM...

Never had fragmentation issues with this => http://sqlfool.com/2011/06/index-defrag-script-v4-1

This is insignificant with that little data.

Rambler (11/25/2011)

---

Thanks everyone for responding.

The problem came back (different DB's trans. log this time).

As for the questions, no there are no other I/O related errors on the SQL server or...

Lynn Pettis (11/25/2011)

---

Remi, thank you for taking the time to reformat the code. Yes, it looks like a possible table scan due to the calculations in the CASE clause...

I need the good and bad execution plans (actual, not estimated).

GilaMonster (11/24/2011)

---

I think you mean GF (Grant Fritchey), because last time I checked I didn't work for...

The only paid memeber here...

GilaMonster (11/24/2011)

---

I'm off to the middle of nowhere for a few days (middle of nowhere also known as the Free State). Can you guys keep an eye out for corrupt...

IIRC 0 stops, 2 deletes the trace definition.

Takes both commands to completely eliminate the trace from the system.

Why don't you find the person who started it and ask him to...

This solves all your problems.

http://sqlfool.com/2011/06/index-defrag-script-v4-1

You can run the dvm, you just need to be calling it from a db in 90 mode (this wors even if the other db is...

From the master himself : http://sqlskills.com/BLOGS/PAUL/post/Sample-corrupt-databases-to-play-with.aspx