Very good advice!

The available jobs are in a pyramid, the highest paying jobs are at the top of the pyramid. But, as one goes up a pyramid, there are...

Most errors I run into are due to one or more of the following:

1)

Failure to make use of affordable data-quality defense-in-depth

approaches. Data value constraints were never defined or...

Part of every calculation code deliverable should be another program that independently calculates key subtotals and totals.

The second program can be a set of sql scripts with instructions to fill...

The poor quality of reading comprehension skills in our population is scary.

Part of the reason is that people are not taught critical thinking skills.

Part of it is that...

I've lost track of how many times I've seen documentation like this:

Step 1: Do blah...

Step 2: Do blah...blah...

...

Step N: Do blah...blah...blah...

Important! Before doing step 1, ...

That's a basic mistake...

Steve Jones - SSC Editor (1/20/2011)

---

Good feedback on this, however I'm more wondering if you think the abstract is well written. Does it make you want to go, or not...

Yes, the table has a clustered index.

This morning, I created a table with no indexes and got what I expected, an index=0 record for the table. I created...

In the olden days, computers were very expensive so one company...

Yo! Original Poster! Listen Up!

GilaMonster has REPEATEDLY told you to avoid the approach you are so avidly accepting.

Go back and re-read his comments and links about alternative ways...

As you said, this appears to be a problem. Wouldn't it issue this correlated subquery once per row retrieved?

inner join ConfigArchive CA2 on CA2.NodeID = CA1.NodeID and CA2.ConfigID...

Here's a simple way.

Create a local temp table with an identity column called sort_id, plus all the columns you want in your output query.

Use dynamic sql to populate the temp...

It generally helps when you include the error messages you are getting for a given input...

Put this in front of EXEC (@tsql):

print @tsql;

Inspect what it prints and try to run...

I use extended properties extensively in my own work as a developer.

I am loath to use them on other developer's work as a dba.

That's because when a script gets run...

I can get the DPM files across the wire (I already am, actually).

But that doesn't turn it automagically into a database that is ready to go as soon as I...

Steve, your analogy about the Mission Impossible vs the Mystery Men teams was a good attempt, but it fails in one seriously important aspect.

Even the Mystery Men team "got...