It's hard yes, but people also underestimate how hard it is to formulate the questions that drive the discovery.

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...

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...

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...

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...

"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....

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...

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...

TheSQLGuru (7/13/2008)

---

I still don't understand why you think range scans would be "screwed up" if you have a million integer identity values from 1000000 to 1999999. Actually I 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...

Thanks,

I didn't think so , just some due dilligence.

I guess it'd screw range scans too.

Regards

George