Oh, and for all those who wrote in criticizing the article, give it a rest. The article is very basic, but as some have pointed out, there are people...

Karen Lopez - InfoAdvisors (3/2/2010)

---

All this discussion about what to call these tables points out that we as a profession do a lousy job of defining our profession ;-).

These tables...

Steve Jones - Editor (1/14/2010)

---

I think you're correct about it, but I don't know that having better customer service would necessarily mean that prices would rise a lot. I'm not...

Man, that's enough to give even us one-time Oracle guys a bad name...geez, lighten up a bit! Not everything worth reading is confined to your narrow little world.

Steve, this...

cmcc (1/6/2010)

---

DC, I totally agree - we're seeing self-selection at work. What I ask is, what is behind this self-selection?

In my generation (baby-boomers educated in the 70s) I saw the...

If there previously were 40% and now are 20% it indicates that there's some bias at work. You can't say that women aren't interested, if that was the case, that...

Bru Medishetty (11/22/2009)

---

tho.pfaff (11/21/2009)

---

ordinary queries grap the rows from the hard-disk, where the cpu needs more time to grap them. and erery time the sql-query is executed the a full...

No, according to the ANSI standard trailing blanks are never ignored for comparison. And as you found out, even turning the ANSI_Padding off doesn't affect how variable values are...

I didn't see that Lynn had posted a solution, but in looking at it, that's pretty much the direction I was headed anyway...

When you have a nonclustered index seek that winds up being more expensive than an index scan you are probably also getting a Key Lookup. Which in turn means...

Sorry to tell you this, but I think you are in for creating a bunch of temp tables. You can't execute a stored procedure from within a function or...

If you are really tied to that table design, post the ddl and I'll see what I can come up with.

I'm sure you could write some pretty ugly sql to get this done, but just how married to this table schema are you? The design of this table makes...

This is one of those kind of weird things that you just have to keep in mind... ansi_padding is an option that controls this behavior, but it works a...

The EXCEPT function under the covers is doing the same thing as the NOT EXISTS, at least in my limited testing.

There is one major drawback to the EXCEPT function and...