Good one, Kit.

"I'm telling you that query is a KILLER.... look at the BONES, man!!"

The problem with this is that a lot of companies, the reason they need a DBA is precisely because they don't have anyone who can screen the answers given in...

For future reference, a very thorough discussion of this topic can be found in the discussion of the following article. A variety of solutions, performance considerations, and other...

Personally though, I would rather have a smart, motivated person with very little knowledge but the ability and eagerness to learn, than a moderately knowledgeable person with no willingness to...

I've been invited to attend interviews of candidates who list SQL skills on their resumes. I used to waste a lot of time doing this. My game...

Undocumented system stored procedure: sys.sp_MSGoBackInTime ??

I vote with Bruce, it would be nice to get a summary every hour or half hour that just says "New activity in the following threads you belong to." ...

It was a dark and stormy night.....

On the subject of books, let's keep in mind that there is a difference between textbooks and reference books. Textbooks teach...

I tried ... closest I could get was "naieve bayes algorithm" which, curiously, I had already heard about recently.

Yes it was, but we now have the address standardization routines in place. (You didn't mention things like...

P.S.

I send IMs to the guys in the next cube all the time... you can cut and paste code, or whatever, and not bother all the other folks who are...

Correlated sub-query?

CorrELATed sub-query?

No wonder I haven't been able to find anything !!!!!

I've been trying to search for CORRUGATED subqueries !!!! :w00t:

---------------------------------------------------------------------------------------------

Seriously, even reading the manuals...

Again, the point is not to delete a valid address from the primary address table just because one user quits using it.

That was my experience the one time I visited... I got to experience a "Southerly" and saw the temperature drop 20 degrees in under an hour.

But everything I saw...

Thanks, Bruce.

With the data we're currently working with, I find that the percentage of orphans is more than made up for by the reduction in duplicates.

You're right...