Forum Replies Created

Viewing 15 posts - 33,271 through 33,285 (of 59,102 total)

  • RE: A Little Interviewing Advice

    No problem. I'll send you my leftovers. 😀

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

  • RE: loops

    LutzM (7/11/2011)


    It's the same like arguing if a horse will be the better choice than a mule in terms of average speed over a long distance when there's a motorbike...

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

  • RE: loops

    GPO (7/17/2011)


    Go Jeff... Go Jeff...

    Incidentally, I don't get the pork chop reference.

    Ok... here's my rather long winded, high velocity Pork Chop reply...

    http://ask.sqlservercentral.com/questions/75404/strip-all-but-alpha-chars-out-of-a-string?page=1#76191

    The "Pork Chop" reference comes from a much older...

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

  • RE: loops

    mister.magoo (7/17/2011)


    The Dixie Flatline (7/11/2011)


    If anyone would post up some examples where a cursor solution outperforms a set-based solution, I will look at them respectfully.

    Bob

    This brought back memories of a...

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

  • RE: loops

    GPO (7/17/2011)


    Hi Bob (Dixie etc)

    Re:

    If anyone would post up some examples where a cursor solution outperforms a set-based solution, I will look at them respectfully.

    Here's an interesting discussion I...

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

  • RE: order by some records only

    CELKO (7/16/2011)


    Jeff, I now call the list of integers table the Series(seq) table because SEQUENCE is a reserved word for a new construct.

    Hmmm... Joe, I have to ask... Since the...

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

  • RE: Create View- T-SQL Syntax error

    SQLkiwi (7/16/2011)


    I normally write such stubs the other way around, to avoid all that tedious messing about with quotes in the view definition:

    IFOBJECT_ID(N'dbo.MyView', N'V')

    IS NULL

    EXECUTE ('CREATE VIEW dbo.MyView AS SELECT...

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

  • RE: Create View- T-SQL Syntax error

    opc.three...

    IIRC, in the "CREATE or REPLACE" in Oracle (and, I believe, in the ANSI standard), the "REPLACE" is equivalent to an "ALTER".

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

  • RE: A Little Interviewing Advice

    TravisDBA (7/16/2011)


    Jeff Moden (7/16/2011)


    TravisDBA (7/15/2011)


    I'll take a good ADMIN over a good query person every time. 😀

    I'm greedy... I want and get both in the same person. 🙂 It...

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

  • RE: Are the posted questions getting worse?

    WayneS (7/15/2011)


    Lynn Pettis (7/15/2011)


    Chad Crawford (7/15/2011)


    Craig Farrell (7/14/2011)


    Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real...

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

  • RE: A Little Interviewing Advice

    TravisDBA (7/15/2011)


    I'll take a good ADMIN over a good query person every time. 😀

    I'm greedy... I want and get both in the same person. 🙂 It sometimes takes a...

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

  • RE: loops

    kritika (7/14/2011)


    all,,

    i got my solution... thanks newaz...

    Very cool. Would you mind posting it so that others may learn from your experience, please?

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

  • RE: order by some records only

    Correct me if I'm wrong, Joe, but the SEQUENCE construct is only new to SQL Server... it's been around in products, like Oracle, for a very long time.

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

  • RE: How to get count for week range?

    Except for in a function or view where you can't actually use a SET statement, I have no problem with the idea of setting DATEFIRST to whatever I need it...

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

  • RE: Too much for too little

    Nilesh Deshpande (6/28/2011)


    Hi,

    I work on a sql server 2000 database at office and then at my residence.

    Till now, when the database size was small enough, I used to do...

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

Viewing 15 posts - 33,271 through 33,285 (of 59,102 total)