Viewing 11 posts - 1 through 11 (of 11 total)
It's hard yes, but people also underestimate how hard it is to formulate the questions that drive the discovery.
December 5, 2017 at 1:34 am
It's not so much a case for cursors as education by/for designers in using the right tools for a given use case.
Most developers begin with a row-by-row education then progress...
September 9, 2016 at 2:10 am
While the article initially reads as plausible, a little critical though will raise questions.
Presenting a couple of downsides for a particular use case doesn't make and anti-pattern.
Some statements seem...
February 4, 2016 at 1:25 am
Over time I've realised that while I have enjoyed development using a dozen or so database and non-database languages (and still enjoy it) development by its nature rarely looks at...
November 18, 2015 at 2:43 am
CAP isn't really out of date, it's a statement of fact. Fine it may not be a problem in all cases but that doesn't invalidate it.
If I go to an...
October 21, 2015 at 8:23 am
"In the rest of the data world,..."
I think the data world outside of the physical database is starting to mature, driven by governance which will be driven regulatory oversight....
January 3, 2014 at 2:58 am
Here's a quick 2005 example of a single select using a tally table.
stage 1 uses a tally table to generate a set of dates.
stage 2 adds a date enumeration...
February 18, 2009 at 5:21 am
One of the alternatives I'm looking into is to replicate the DB2 tables into another DB2 schema. The ETL process can then pick up the DML'd rows from the replicated...
July 17, 2008 at 8:14 am
TheSQLGuru (7/13/2008)
July 14, 2008 at 1:10 am
Assuming you are using some form of integer as identity, you have a misconception about actual byte storage in the low-level workings of a computer. Recall that integer is...
July 13, 2008 at 12:50 pm
Thanks,
I didn't think so , just some due dilligence.
I guess it'd screw range scans too.
Regards
George
July 10, 2008 at 8:39 am
Viewing 11 posts - 1 through 11 (of 11 total)