Still not going to help on a DATETIME column... A DATETIME column uses only the default system format when displaying data. If you want something else (should be done...

I'd rather have more memory so more data can be cached. Also, no matter how fast the processor is, bad code (usually some form of RBAR) is the great...

See the UFL in my signature line for some help on that...

Ah... thanks for the explanation, Gail... I just figured it out... the reason they need to do the GROUP BY on a comments column is because they're writing an aggregate...

GilaMonster (4/10/2008)

---

At my current place we start with the technical interview. Since we're curently looking for people to do performance tuning and monitoring, I'll usually start with a very simple...

Nicely done...

Nuh uh... some of us recommend BULK INSERT... BCP would require a trip to the operating system, possibly via xp_CmdShell... that's why I recommended BULK INSERT. I didn't recommend...

jezemine (4/10/2008)

---

Jeff Moden (4/9/2008)

---

Heh... my very first question is "How do you get the current date and time using a query". Believe it or not, about 1/4 of the...

Dumber and dumber is right... they should have left it alone... 2k had a fine optimizer... well, the idiocy started at SP4 which is why I still run sp3a on...

You're trying to group on a comment field? :blink: As I've asked a couple of times now,...

Steve's suggestion is good, but use NVARCHAR(MAX) instead... 3rd party either made the original column NTEXT for a reason or because they're stupid... you have to account for either eventuality....

And a sample of what's in the NTEXT column please... it's hard for me to imagine why you'd want to group on something that can be 4000 bytes long...

Nope... not if...

One other thing that has been covered on previous such posts to a very great extent. Never lie and never stretch the truth on an interview... heh, and pass...

Nicely done, Peter!