• Eugene Elutin (9/6/2012)


    Luis Cazares (9/6/2012)


    CELKO (9/6/2012)


    Most of the work (80-95%) in SQL is done in the DDL. Messy, complicated DML is almost always the result of poor DDL. This is what he needs! Giving him kludges assures he will never learn to be a good programmer.

    If this was a woodworking newsgroup and someone posted "What is the best kind of rocks to pound screws into fine furniture?" are you really helping them when you say "Granite! Use big hunks of granite!" I am the guy who replies with "Your question is bad. Don't you know about screwdrivers?"

    I agree, with good DDL most problems would be solved even more easily. However, most people in these forums aren't able to change that and have to work with what they have.

    Don't we know about screwdrivers? yes, but we can't afford them. What should we do in that case?

    Can you get the point?

    "Granite! Use big hunks of granite!". I would add also: polish it first!

    It's cheaper than a screwdriver, and from performance point of view it can be much faster... :hehe:

    I just can't stop laughing at this. :hehe:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2