Forum Replies Created

Viewing 15 posts - 16,231 through 16,245 (of 59,067 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/22/2016)

    Have to drop this here, since I'm proud.

    My son completed his Board of Review last night to earn his Eagle Scout rank. It's been 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)

    November 22, 2016 at 8:58 pm

    #1914151

  • RE: Trigger causing deadlocks

    zoggling (11/22/2016)

    The estimated execution plan only shows marginal gains for this trigger definition when compared with the original, and also suggests a similar index be created. We will re-consider 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)

    November 22, 2016 at 6:15 pm

    #1914146

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    carl.thompson (11/22/2016)

    Hi,

    Thanks for the article Jeff.

    Would anyone be able to explain the relevance and importance of using 'WITH SCHEMA BINDING' with this function please?

    Thanks,

    Thanks for the feedback, Carl. Looks...

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

    November 22, 2016 at 2:44 pm

    #1914133

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Ed Wagner (6/22/2016)

    David Moutray (6/22/2016)

    Classic article, Jeff. I have loved it (and used it extensively) since it first came out five years ago (and the discussion is still going...

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

    November 22, 2016 at 2:43 pm

    #1914132

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Ed Wagner (11/22/2016)

    carl.thompson (11/22/2016)

    Hi SSCrazyEights,

    Thank you for your reply.

    That makes perfect sense and I think confirmed what we thought to be the reason for the inclusion in the function....

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

    November 22, 2016 at 2:39 pm

    #1914131

  • RE: Change Detection with (44) Columns!

    Phil Parkin (11/21/2016)

    Jeff Moden (11/21/2016)

    Phil Parkin (11/21/2016)

    Jeff Moden (11/21/2016)

    Why not just use EXCEPT?

    EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be recommended, IMO.

    Now...

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

    November 22, 2016 at 2:36 pm

    #1914130

  • RE: What is Normal?

    Eirikur Eiriksson (11/22/2016)

    Jeff Moden (11/20/2016)

    Eirikur Eiriksson (11/20/2016)

    I'm strictly for the full most practical normalisation with one exception, carrying forward a very carefully selected keys such as Invoice-->InvoiceLine-->InvoiceLineDetail(InvoiceID) where, at 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)

    November 22, 2016 at 2:28 pm

    #1914129

  • RE: What is Normal?

    ZZartin (11/22/2016)

    RonKyle (11/22/2016)

    And if you're one of those folks that think you can identify customers or accounts by some form of natural key because "IDENTITY" columns are supposedly evil, then...

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

    November 22, 2016 at 2:26 pm

    #1914127

  • RE: Find the brackets

    adman3613 (11/22/2016)

    now i see its not like '[ then [] its actually like '[] with the [ inside the brackets .

    thanks for the article ... ive used the brackets...

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

    November 22, 2016 at 2:24 pm

    #1914126

  • RE: Find the brackets

    adman3613 (11/22/2016)

    Im not sure i understand your use of like

    i get the like '[ and even the wild card % but not the inclusion of the additional set 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)

    November 22, 2016 at 5:32 am

    #1913956

  • RE: Change Detection with (44) Columns!

    Phil Parkin (11/21/2016)

    Jeff Moden (11/21/2016)

    Why not just use EXCEPT?

    EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be recommended, IMO.

    Now you have me curious......

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

    November 21, 2016 at 5:47 pm

    #1913893

  • RE: Change Detection with (44) Columns!

    Why not just use EXCEPT?

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

    November 21, 2016 at 4:40 pm

    #1913888

  • RE: Are the posted questions getting worse?

    Gazareth (11/21/2016)

    CMD / Powershell change in Win 10 I don't think has been well reported.

    My understanding is that the only change is that the "cmd" command & the icon on...

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

    November 21, 2016 at 9:13 am

    #1913780

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/21/2016)

    Steve Jones - SSC Editor (11/21/2016)

    Out for a few days, but I'm back.

    WRT the PoSh instead of the Command Prompt, I'm not sure there's a big issue here....

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

    November 21, 2016 at 9:10 am

    #1913778

  • RE: Are the posted questions getting worse?

    Phil Parkin (11/21/2016)

    Brandie Tarvin (11/21/2016)

    Ed Wagner (11/21/2016)

    Phil Parkin (11/21/2016)

    Ed Wagner (11/21/2016)

    Phil Parkin (11/21/2016)

    Ed Wagner (11/21/2016)

    Jeff Moden (11/21/2016)

    I have to do some more research on it but it may be 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)

    November 21, 2016 at 8:52 am

    #1913765

Viewing 15 posts - 16,231 through 16,245 (of 59,067 total)