Why use the cross join?

SELECT *

FROM PersonRecord A

INNER JOIN PersonRecord B

...

For a counterpoint, look at Paul Graham's site, http://www.paulgraham.org, under the essays

--

JimFive

Steve,

That's not strictly true. The more load...

Steve,

Great to see it working out for you. Your numbers at the bottom don't look right, however. It looks like the "conservative" and "realistic" numbers might be swapped.

--

JimFive

I think one thing that needs to be considered is that Eric is competent. He's not outstanding, but he grinds along and does the job they hired him for....

First, I would expect the waiver mentioned in the article would hold up as long as the workers were not required to be checking their email outside of work hours....

I do understand that an Index on this theoretical "Bitmask" column would be expensive to maintain, but how is Indexing a Bitmask column any different than say a "LastName" column?...

It seems that everyone is taking extreme positions on this topic.

There is no real difference (performance, security, or maintenance) between using SQL in your DAL and using sprocs via a...

It seems to me that the term "IT guy" implies that Computers are a hobby for the person, not (just) a profession. While that's not all bad it does...

I don't think that the fact that the query compiles is a bug per se. It compiles because subqueries must have access to their parent in order to create...

David,

You are, of course, correct. The best way to store a choose-many would be just to record each answer in a table like: SurveyID, QuestionId, AnswerID [AnswerText]. ...

webrunner,

Change that to varchar(8) and it will work.

'20080520AB' cannot be converted to a date, but '20080520' can.

--

JimFive

I'd have to dig out my Programming Languages text to see if SQL meets the definition, but I'm pretty sure it does. I vaguely...

I think everyone is missing the point of what is happening.

What is occuring is an automatic type conversion. If I do this:

Declare @Tmp datetime

set @Tmp...

I'm going to go out on a short limb here and say: XML is an even worse idea than EAV. EAV Creates a weak data type design while XML...