I wish great authors would warn people of the code the create. ...

I built a million row table as you described. I made it so that the Status column has only 5 different possiblities and verified the distribution as an average...

Adding columns to a temp table or any table that uses ALTER is always a PITA... during run time, the new columns are perceived as NOT THERE. That means...

It simply substracts 2 from the character position returned by the FINDSTRING.

madeley68 (3/12/2008)

---

I will do that, strangely I need that on my main table, which has just north of 1.1 Million rows at the minute, I did get a program written...

Now there's an idea... and properly partitioned, it would be updateable, as well.

Perfect... thanks for the feedback!

Lynn Pettis (3/11/2008)

---

Jeff, Only problem with that, what if they don't have the budget for Enterprise Edition? That puppy can get expensive at street prices, and most discounts that...

Great link for a "System DBA", Adam. What about an "Application DBA" or a "Hybrid"?

Isn't a DB2 timestamp is listed in seconds since some date? Are we chasing a ghost just because the OP said "it used to work"?

Heh... and, still, you have to pay attention to the title... "ESTIMATING the size of a clustered index."

Brandie Tarvin (3/12/2008)

---

You know, someone should mention (for the lurkers), that Jeff actually paid attention to the Corporate Culture before "letting loose". He didn't just do it without having...

Matt Miller (3/12/2008)

---

What if I show up to the interview dressed as a Dwarven Fighter with 1.9M experience? How does THAT play??? I'll leave the ax at the...

Then, pick one of the two methods in the code I demo'd above...

Sorry... the table is pretty much toast, then.