...whole books, hundreds of chapters, and thousands of Internet articles have been written on the subject and it's impossible for me to cover all of the aspects of the subject...

Would it be fair to say that in nearly all the examples here, the “raw” data simply wasn’t raw enough? As soon as you’re pulling data into your ETL system...

I'm gonna print that out and stick it on the wall of my office and make people read it to...

Good article, Jamie. We should apply the principles espoused therein to forum posts as well. A word of caution though. If you're going to us spelling and grammar checking software,...

Regardless of the integration or compilation technique, 10 million lines of code may be an advertisement for how to do things badly, not well. Over a year ago, I walked...

Just because the relational model has a very good track record, doesn't mean we shouldn't be careful what we take for granted. For example, if someone had told me even...

There are four things to take away from this thread.

1. Celko is right.

2. Celko has a few runs on the board. He's better qualified to comment than most.

3. A calendar...

+1

Got it right because I guessed what the op was getting at but I think the question should have been proof-read and tidied up before publication.

I wonder whether all SELECT * in views are created equal. That is to say equally evil. For example is a SELECT* from a preceding CTE just as bad...

Don't suppose that picture of the fish is a veiled reference to poisson?

A stunning contribution to the discussion Dwain. The SQL Server world just got a little better.

Haven't tested it yet, but on face value it looks really quite superb. Many thanks.

L' Eomot Inversé (6/13/2012)

...Even when I didn't have full control, I usually had a recruitment veto (since the late 70s, anyway, and I didn't meet any DBAs before then) so...

Now that we're all up-to-speed on generating test data, 😉 you know what would be trez cool (not suggesting that Jeff should have to do it, but it would be...