... and index that new column.

P.S. Nice detailed script Lowell!

Ken Davis (7/26/2011)

---

It occurred to me, I am on my company's network now. A policy may be stopping the download. I will try it when I'm off the...

SET DATEFORMAT YMD

Then try the delete

or

Where char column <= '20110626' -- you can easily rebuild that part out so that it's dynamic.

Very nice script Jason... going to my vault.

Just finished download and didn't have any issue.

SQLRNNR (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit...

Sounds like the only real solution is awesome (proper might not be enough) pre-planning and growth analysis.

Sounds like a lot of fun!

While wasting more time on this...

On another note, the only safe backup I know is the one I've successfully restored and then ran an error-free checkdb() on it. And...

Ya but if you want to minimize downtime you could possibly just copy the data, then do the switching. That way the downtime would be minimal.

Could partitioning be used...

All 3 files downloading fine at the moment (download 32 bit version, US english). I'm based in canada so maybe I hit a different download server.

I'll let it go...

My first guess would be implicit converts... nullifying the indexes.

Can you post the query, table ddl, index & keys DDL along with the actual execution plan (not estimated).

GSquared (7/26/2011)

---

Tom.Thomson (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary...

Ok, but you'll leave him waiting like that for the real answer? 😉

ALZDBA (7/26/2011)

---

Grant Fritchey (7/26/2011)

---

Can't help it, I have to share. I was doing some Boogling or Ginging, whatever we call it now, when I stumbled across a really scary bit...

Chazz88 (7/26/2011)

---

Ok then, so I need to write a query for this. I know what column I want to order this one troublesome table by but what would the query...