fuller.artful (2/11/2008)

---

... The Sex column is obvious, but I think so are columns such as StateOrProvince, in which there are a small number of uniquely identified entries. Countries is another...

I think a lot of good information gets lost in the debate between natural keys and surrogate keys. Anyone who doesn't have a good understanding of keys (primary keys,...

That insight is exactly my point. Personally I'm not a big fan of "games" and I...

gordon_griffin (2/7/2008)

---

I have to say, if as a manager my interviewing questions avoided someone with Michael Coles' attitude (from the referenced blog entry) joining my team, I'd regard that as...

For me the biggest question isn't so much "could this be a technique to see how you respond?", but rather do I want to work for/with people who think it's...

That's a common error when you're trying to login with Integrated Security but it doesn't recognize the account name. If this server is now on a different domain, it...

Martin Bastable (1/2/2008)

---

...

We contacted the suppliers and talked to a developer.

....Yes we use count(*) so our system can check if a table exists with a particular copy of our software...

Jeff Moden (1/1/2008)

---

Thanks for the great feedback and the code examples, Mike. Heh... "dark side" indeed... I hate XML 😛 Still, it seems that's the way a lot...

Oops you're right, I did miss that code block. I think the speedup is not really due to UDF overhead though, but rather because of FOR XML and xml...

Nice, as always, Jeff. I notice you said you didn't do any testing on 2005. If you do more testing on 2005, be sure to try out the...

It took me 4 hours to upgrade a laptop from Vista to XP, and I'm still a couple of device drivers short. It should be a Class B Felony...

Steve buddy, you've been doing this too long 🙂 J/k, very funny and merry festivus!

John Rowan (12/3/2007)

---

Mike C (12/3/2007)

What's the proper etiquette when the OP posts a question in the 2000 forum, and subsequently asks "is there an easier way to do this in...

John Rowan (12/3/2007)

---

GilaMonster (12/3/2007)

---

Likewise. I only...

Jeff Moden (11/27/2007)

---

Jason Selburg (11/27/2007)

---

Lynn Pettis (11/27/2007)

---

Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse...