Forum Replies Created

Viewing 15 posts - 26,011 through 26,025 (of 59,102 total)

  • RE: What is RBAR? How can I avoid it?

    bjesmith2 (1/26/2009)

    Jeff,

    All of your responses were excellent! I was astonished by the number of replys to what I thought would be an afterthought question for most of you. I truly...

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

    September 2, 2013 at 10:06 pm

    #1646850

  • RE: Please help with a Trigger

    abdel_mesbah (9/2/2013)

    Hi there,

    thank you for the reply and didnt mean the kind of as I dont know what I want 🙂

    thats what I am capturing at the moment

    Maincase

    ID ...

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

    September 2, 2013 at 8:55 pm

    #1646846

  • RE: sql query

    dwain.c (9/2/2013)

    Jeff Moden (9/2/2013)

    Same goes for another atypical method (the "Multi-Pass" update) that a chap by the name of "Hugo" wrote.

    My curiosity has been piqued. Would this be Hugo...

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

    September 2, 2013 at 8:40 pm

    #1646844

  • RE: List objects to move

    If they're moving the app to another server, I'd hope they'd be moving the data, as well. Why not skip all the work with scripts and just do 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)

    September 2, 2013 at 7:35 pm

    #1646841

  • RE: sql 2012 dumps

    ramyours2003 (9/2/2013)

    Can any one send the sql 2012 dumps for getting the certified ?

    No.

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

    September 2, 2013 at 6:39 pm

    #1646836

  • RE: high cpu and parallelism

    Abu Dina (9/2/2013)

    You no longer MCM?!

    They're cancelling the MCM cert.

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

    September 2, 2013 at 6:25 pm

    #1646835

  • RE: IF Statement based on Multiple SELECT Statements

    wak_no1 (9/2/2013)

    Luis,

    Thank you for the reply.

    I have though worked it out! I used a JOIN in the IF statement, If the results of the Join were > 0, the script...

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

    September 2, 2013 at 6:22 pm

    #1646834

  • RE: Match Varbinary(max) with another Varbinary(max)

    chirag ~ (9/2/2013)

    i have a table with one binary column. that contains 0x00010100000101010101......00 column datalength is 35040, i am prepare this data like

    @Jobbyte = COALESCE(@Jobbyte , 0x) + Cast ((Case...

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

    September 2, 2013 at 6:16 pm

    #1646832

  • RE: sql query

    Erland Sommarskog (9/2/2013)

    I assume that you mean set-based iteration. That is by no means an atypical method, but one a good SQL programmer should master.

    Yes and absolutely agreed. That's...

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

    September 2, 2013 at 6:05 pm

    #1646831

  • RE: Are the posted questions getting worse?

    I'll probably never go for the MCM or any other certification that MS has to offer (now that I've seen what MS does with the cream of the crop, I'm...

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

    September 2, 2013 at 5:41 pm

    #1646830

  • RE: sql query

    ramya.usapp (9/1/2013)

    Hello friends,

    Please help me in writing a query!!

    Question:

    Write a query based off of the following data stored in the AccountingEntry table. The query needs to return running totals...

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

    September 2, 2013 at 12:50 pm

    #1646795

  • RE: Help

    OTF (9/2/2013)

    I think people spend way more time than they should denegrating Certifications.

    I have to disagree in this area. I've had to work with a fairly large number of...

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

    September 2, 2013 at 12:10 pm

    #1646789

  • RE: Get data month to calander week

    farrukhhameed786 (8/29/2013)

    I have attached a workbook to have a Idea how I need it.

    So... according to that partial spreadsheet (week 1 is missing a label as is the last week...

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

    August 31, 2013 at 1:07 pm

    #1646590

  • RE: I partitioning ever simple?

    taigovinda (8/30/2013)

    Thanks Jeff.

    From the looks of it I think there are a lot of other things I should learn before partitioning.

    Do you think that if I know 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)

    August 31, 2013 at 12:44 pm

    #1646586

  • RE: how to write query

    I don't need to run it from SQLCMD to see why. I've already demonstrated "Why" in the article. 😉

    So far as "Developer Productivity" goes, I'm all for that. ...

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

    August 31, 2013 at 12:38 pm

    #1646585

Viewing 15 posts - 26,011 through 26,025 (of 59,102 total)