Forum Replies Created

Viewing 15 posts - 12,166 through 12,180 (of 59,095 total)

  • RE: The SQL Saturday Thread

    Ed Wagner - Wednesday, June 6, 2018 5:38 AM

    Jeff Moden - Tuesday, June 5, 2018 4:57 PM

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

    June 6, 2018 at 6:09 am

    #1993069

  • RE: detect if previous record is higher or lower ?

    Ugh!  I'm going to have to take it back.  I'm assuming that you want the return to return to the screen.  If that's the case, then the "Quirky Update" is...

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

    June 5, 2018 at 9:54 pm

    #1993047

  • RE: The SQL Saturday Thread

    Jason A. Long - Tuesday, June 5, 2018 2:39 PM

    Jeff Moden - Tuesday, June 5, 2018 11:42...

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

    June 5, 2018 at 4:57 pm

    #1993042

  • RE: The SQL Saturday Thread

    Just found out my 2 session presentation on "Black Arts" Index Maintenance has been accepted for Columbus, OH on July 28th.  Really looking forward to 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)

    June 5, 2018 at 11:42 am

    #1992987

  • RE: Regulary delete and rebuild of table influences perfomance?

    ktflash - Tuesday, June 5, 2018 12:53 AM

    I have attached the full create statement for the table, the execution plan and...

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

    June 5, 2018 at 8:28 am

    #1992963

  • RE: detect if previous record is higher or lower ?

    I'll try to hammer out an example tonight after work, Mick.  Sorry for the delay in responding.

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

    June 5, 2018 at 7:50 am

    #1992958

  • RE: Regulary delete and rebuild of table influences perfomance?

    Gaps in an IDENTITY column will have no affect on performance.

    Gaps on pages due to freespace created by deletes could (but usually not a real serious problem unless...

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

    June 4, 2018 at 6:42 am

    #1992802

  • RE: Will Coding Be Less Important?

    xsevensinzx - Monday, June 4, 2018 6:01 AM

    Jeff Moden - Sunday, June 3, 2018 7:54 AM

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

    June 4, 2018 at 6:31 am

    #1992798

  • RE: Will Coding Be Less Important?

    David.Poole - Monday, June 4, 2018 2:19 AM

    Those man weeks we had spent coding, testing and integrating could have been achieved in...

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

    June 4, 2018 at 5:05 am

    #1992785

  • RE: Query

    jagjitsingh - Sunday, May 27, 2018 10:44 AM

    Hi

      I have below Data .

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

    June 3, 2018 at 7:54 am

    #1992758

    Viewing 15 posts - 12,166 through 12,180 (of 59,095 total)