Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • RE: Can Data Save the World?

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

  • RE: A Case FOR Cursors...

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

  • RE: Queues in Databases

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

  • RE: Relational By Default

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

  • RE: An Out of Date CAP

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

  • RE: Looking to 2014

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

  • RE: SQL Function : Find ‘X’ Business Days in the Future

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

  • RE: Is there a way to replicate DB2 data to SQL 2005?

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

  • RE: Reversing column values for an index

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

  • RE: Reversing column values for an index

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

  • RE: Reversing column values for an index

    Thanks,

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

    I guess it'd screw range scans too.

    Regards

    George

Viewing 11 posts - 1 through 11 (of 11 total)