Alvin Ramard (2/23/2009)

---

Jack Corbett (2/23/2009)

---

How else would you refer to The Thread? We do not the gender...

Or, to avoid system tables which can and do change:

SELECT COUNT(*)

FROM INFORMATION_SCHEMA.ROUTINES AS r

WHERE ROUTINE_TYPE = 'PROCEDURE'

I agree. I'd look at the execution plans. But you should also check the indexes on the two systems for differences in fragmentation. I'd also look at the statistics on...

Through our testing and long-term production maintenance on several systems using wider clustered indexes, I've found that fragmentation, even on systems with lots of inserts, is not that big a...

Kit G (2/21/2009)

---

I got hooked in high school, played in college and have kept it up sporatically afterwards. And while I can't say that I lost any days... I...

Credit where it's due.

And now I've spammed the endless thread.

Sorry everyone, sorry, I just got carried away.

Lynn Pettis (2/20/2009)

---

David Webb (2/20/2009)

---

Hmmmmm...

So many AD&D players.

DM: The OP has just sprung from behind a large pile of unread MSDN Library DVDs, wielding an update query with no...

Lynn Pettis (2/20/2009)

---

Uh oh. I think you helped him with your last...

Lynn Pettis (2/20/2009)

---

Hey, I'm just trying to give him apples to compare to apples. I actually agree with you for the most part. I'm sure I can find...

I quit. He's on his own. Total failure.

But...

Putts (2/20/2009)

---

forgive me for being blunt by why would anyone do a distinct that is going to return the same number of rows as the full SELECT?

The whole point (at...

Lynn Pettis (2/20/2009)

---

Grant Fritchey (2/20/2009)

---

But that example compares one thing you shouldn't do, SELECT *, with another thing that has serious enough costs that it almost needs to be in...

Heck, he's gone full circle and started posting his first message all over again.