We finally have 2005 installed (on the same server as 2000) in dev and don't have it in production... though that's sched Sunday.

No one wants to pay for a migration...

Jeff Moden (3/5/2008)

---

... I've found that there are performance penalties... doing a split on a VARCHAR(MAX) with about 7000 characters takes 250 to 485 milliseconds. Doing the same split...

Andy,

Thanks for the article. You solved a problem I was having.

I need to rewrite a web app where the users "need" to be able to put thousands of bytes...

Matt,

ABSOLUTELY agreed. And I still believe that wizards are in part at fault for making (allowing?) people to make bad decisions by assuming that the default is right in...

William (1/29/2008)

...that is not justification for allowing anyone to arbitrarily set a delivery date. The Marketing and the Sales people as well as a 4 year old are...

Oh, that makes sense. I've heard the term "candidate field" (with the meaning being "one of the fields in...

Michael Valentine Jones (2/12/2008)

---

See if this example helps:

[simplified by Chris C.]

CREATE TABLE [dbo].[LANGUAGE]...

Okay, with the risk of sounding more ignorant than I am, I'll admit that I get a little lost.

I've been programming for almost two decades, and the terminology I have...

I tend to use identities for every table, and do not tend to expose them to the users (if they said product ids are unique and they later end up...