Viewing 15 posts - 3,721 through 3,735 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 19, 2009 at 8:31 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 19, 2009 at 7:41 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 19, 2009 at 7:34 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 19, 2009 at 7:02 am
Undocumented system stored procedure: sys.sp_MSGoBackInTime ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 18, 2009 at 2:39 pm
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." ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 18, 2009 at 2:14 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 18, 2009 at 9:03 am
I tried ... closest I could get was "naieve bayes algorithm" which, curiously, I had already heard about recently.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 17, 2009 at 6:43 pm
detecting duplicates is even more difficult than these other issues
Yes it was, but we now have the address standardization routines in place. (You didn't mention things like...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 17, 2009 at 6:40 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 17, 2009 at 6:32 pm
"correlated sub-query"
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 17, 2009 at 6:26 pm
Again, the point is not to delete a valid address from the primary address table just because one user quits using it.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 17, 2009 at 4:19 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 15, 2009 at 2:18 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 15, 2009 at 1:21 pm
I just looked at this post again and realized I need to revise my recipe. There is really no need for a table variable here, a cte is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
February 15, 2009 at 10:15 am
Viewing 15 posts - 3,721 through 3,735 (of 4,080 total)