Now that the religious(ish) discussion of heap vs. clustered has been resolved let's circle back to the original post.

IMHO it was a teachable moment for us to reach many newbies...

Queries which are taking time are of type,

SELECT ......

FROM SomeTable WITH (NOLOCK)

WHERE SomeColumn BETWEEN 47300 AND 47315

There are 4 tables which are similar to SomeTable and involved in similar query...

After creating...

This may sound wierd but at home I like New Age on softly as background, but working in my cube and having to use headphones I find I cannot turn...

First off thanks, like others I had not stopped to think about "d" and "e" and I am a little surprised "x" was not included if they were. go figure.

However,...

It just occurred to me what the equivalent of this thread would have been in 1925 discussing what we now call Interstates or Autobahn, etc.

The deer or children on the...

1. The negation in the question is a needless extra complication. It would have been better to ask which of the listed rules are correct. (Even after realizing that the...

Here is the short answer: if you use any aggregate function in the select list (sum, min, max, count, etc.)

then you MUST either:

A) have ONLY aggregate functions in the select...

Actually, I was looking at it as a real estate investor (which I am...

Politicians spend billions on fixed guideway (train) systems that can't even carry enough passengers to make up for a single lane of highway capacity ... rather than spending the mere...

The routes are fixed, and need to be virtually linear. Compare that with buses, which can go virtually anywhere and can alter routes to suite changing ridership, rather than trying...

I think the editorial and most of the comments are setting the bar too high.

The system does not need to have cars inches apart to move traffic better, just take...

I can see us evolving some businesses to having a "guidance counselor" who approves our expense reports, performs periodic reviews, helps us manage our careers, and is available to discuss...

I was called in once where a procedure went from running in less than a second to many minutes. Since the procedure was called multiple times for each order picked...

Let me start by saying that I quite agree with the initial point of the article. When confronted with a complex SQL problem you are better off thinking in Venn...