I'd think (from a performance standpoint) using LIKE is the *last* thing you'd ever want to do. Especially the "Like %X%" construction, since at best it's going to do an...

James Stover (8/10/2010)

---

First, small businesses should not be exempt from the rules, nor the penalties. I do agree that the penalty should be appropriate to the size of the business....

As always, the devil is in the details.

First, who's going to be subject to the regulations? Is it only for "large" companies? Or everyone? If everyone, then *everyone* will...

Depressing.

What's even worse is the realization it's *NECESSARY* to have such a large body of collected knowledge. In my humble opinion (hah!). Having to know so much means SQL Server...

Amen to readability, and a double-plus-amen to comments.

You need *both*.

I've been in the unfortunate position of having a boss who considered comments nothing but time-wasting fluff. He reprimanded me for...

Where do you think they got Java's syntax from? 🙂

Any language with C-based syntax (including TADS) is from the...

djackson 22568 (5/21/2010)

---

I haven't coded in VB for a few years (VBSciprt only currently) but what if I want a variable named MyNewVariable and another one named MYNewVariable? Yes,...

Miles Neale (5/21/2010)

---

However the yelling of code and solutions should be questioned. As one who has been involved with security for some time it has been noted that this practice...

Despite the fact I'm an ardent Python fan (and LOVE block indentation!!!!!!!!!!!!!!!!) I can get behind case insensitivity in languages and databases. In fact, except for a very very few...

TheSQLGuru (3/16/2010)

---

The optimizer is INCREDIBLY intelligent. Serious rocket science type of stuff. But it only has so much information to go on and (perforce) a limited amount of...

A very sobering read, as I'm embarking on the from-scratch rewrite of our company's backbone application to use SQL Server (basically it runs the company) and unfortunately I *am* the...

Allow me to be the voice of caution. T-SQL is one of the worst languages around when it comes to sheer drudgery so code-writing programs can indeed be extremely helpful.

However....

David Portas (3/2/2010)

---

RalphWilson (3/2/2010)

---

If you just arbitrarily do things like using IDENTITY_INSERT or reseed the Identity column, then, IMHO, you deserve to have problems. If you don't screw around...

Les Cardwell (3/1/2010)

---

Of course it creates issues... I'm dealing with a wagon load of such right now due to the fact that the legacy system did not use a WO#...

I favor using identities in *almost* every table, even those that have one or more natural unique keys. For one thing it makes logging much simpler, a single quad of...