Viewing 15 posts - 4,051 through 4,065 (of 4,080 total)
Programming and managing require two very different skill sets. My best managers were always people with sound judgment and good skills at organizing and supporting their people,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 30, 2008 at 2:20 pm
I'd like a summer vacation, like when I was kid. Ten weeks off with nothing to do but figure out how to best fill up the day....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 12, 2008 at 10:24 am
I have got to start proofreading better. My apologies.
The table being queried isn't 200 million rows, it's closer to 20 (TWENTY).
Also,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2008 at 1:47 pm
... continued after hiccup/entry
exec stGetSales '38655|38677|90210', -- zip codes
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2008 at 1:20 pm
Someone mentioned using joins to table variables as an alternative approach. We've gotten excellent results using that technique where we could declare that all parameters of the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 29, 2008 at 1:09 pm
Hey Graeme 🙂 My wife is still in U.S. education (PreKindergarten-1st Grade) and it keeps getting scarier. Teachers are now expected not only to 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
August 26, 2008 at 10:44 am
These things even out over time. Not everyone in the "younger generation" has it easy growing up, and not everyone who has it easy lacks a work ethic....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 26, 2008 at 9:12 am
Hey lucian
Here is some code for doing parsing using a tally table. We usually have a pre-generated one in each db, but this code will run on...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2008 at 3:44 pm
I agree that Googling for answers to coding problems isn't cheating, anymore than buying a reference book for the same purpose would be cheating. More people should...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2008 at 3:27 pm
My existing parser function uses a tally table like that last example and runs pretty damn quick. The huge CPU performance difference I saw was in building...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 22, 2008 at 1:23 pm
Hey Wayne, I must be on drugs today. Or maybe I'm not and ought to be because of all the typos I'm making today. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2008 at 3:59 pm
Just to answer the rhetorical questions about building xml by wrapping tag constants around data, rather than use a "For XML" statement, we should remember that a lot of code...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2008 at 2:58 pm
Doh! Just realized you are doing a simple select, not an update. My bad.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2008 at 2:23 pm
Why not just put a test in a where clause instead of using the Case statement? That way you aren't even updating all the rows. This...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2008 at 2:22 pm
Good question, and a learning experience for me
I missed it too, not realizing that the underscore wouldn't catch 'C_us'. The lesson learned is that underscore as a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 13, 2008 at 10:33 am
Viewing 15 posts - 4,051 through 4,065 (of 4,080 total)