HEH!! Now, THAT's entertainment 😀

Ah... thanks and sorry... didn't know your background and I took the really conservative route. I'm also sorry that I don't have any recommendations. I've been through a...

I know... pretty bad, huh? Hope they...

Heh... yeah, I've been through that. But I will give you a tip in the form of an old proverb... "Wait not, want not". I busted my hump...

Heh... "the footbone's connected to the... shinbone... the shinbone's connect to the... kneebone..."

Won't be any effect if the Clustered key is on an IDENTITY column.

Heh... sure... it'll affect the "dw" option of the other (not DATENAME) functions... nothing else... even if they were to break it in 2k5 🙂 Pretty sure they didn't,...

Heh... I'm sick too! Sick of working...

David McFarland (10/21/2007)

---

I ran the first code, and I believe I stated as such. That's exactly how it is used on our end, not sent to temp tables, as the...

Awesome, Lowell... thanks!

Sergiy was right... he expected about 2 times faster... sometimes, almost 3 times faster for the Inner Join.

You guys are the best! I'll start working on a...

Hi Loner...

I'd almost bet that Deborah isn't even in IT... she's probably just a reporter making an observation. I don't see where she said "my company" anywhere.

As for the...

BTW... Sergiy, do you have convenient access to a 2k5 box that you could run these tests on? Would be real good if we had a 3rd set of...

Sergiy (10/21/2007)

---

Jeff Moden (10/21/2007)

---

Heh... jury is still out on 2 times... it's starting to look a lot like the hardware or the installation may also make a huge difference. ...

You bet... thanks for the feedback!

Heh... jury is still out on 2 times... it's starting to look a lot like the hardware or the installation may also make a huge difference. Davids times came...