Home Forums SQL Server 2012 SQL Server 2012 - T-SQL display order by like 1,2,3,4,5...............plz write quarie RE: display order by like 1,2,3,4,5...............plz write quarie

  • November 6, 2013 at 1:05 pm

    #1664554

    GilaMonster (11/5/2013)

    Jeff Moden (11/5/2013)

    I'm well aware of that. You and I have had this conversation before and I absolutely agree. I should have said "and that someone is wrong because making good choices as to data type is NOT a pre-optimization."

    Yup. Just putting it out there for those who read this and don't know.

    I think I need to write something on this topic...

    Thanks, Gail. It would be a real pleasure to proof read it for you, if you'd like. I saw a part of something that you did on the "Preoptimization is the root of all evil" thing and it was absolutely awesome.

    I'll also try to remember to add the missing part on the next post that comes up on this subject. I'd left out a really important part on this one until you reminded me.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)