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.

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 the shouldn't do category,...

Putts (2/20/2009)

---

Perhaps I have always just run into the perfect scenarios for using distinct and now have crawled into others where it is not as useful.

Are there certain cases where...

josephptran2002 (2/20/2009)

---

Hello Grant Fritchey,

I have 4 tables such as BOCLEARED, CTCLEARED, NHCLEARED, and TOTALCLEARED.

In table BOCLEARED (given), it includes 3 columns such as

DDS BOCLEARED...