Forum Replies Created

Viewing 15 posts - 23,011 through 23,025 (of 59,067 total)

  • RE: Index and Page Split

    murnilim9 (7/31/2014)

    SQL Guy 1 (7/31/2014)

    What is data type, length, and number of columns?

    How intensively it is used - from sys.dm_db_index_usage_stats ?

    Thanks for your kind response . Appreciate it!

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

    July 31, 2014 at 8:50 pm

    #1734323

  • RE: Today's Humor..

    Grant Fritchey (7/31/2014)

    Sarah Wagner (7/31/2014)

    I hired in to a software company and sad to say we were one of those vendors. Gladly we are not anymore as I rewrote all...

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

    July 31, 2014 at 5:22 pm

    #1734314

  • RE: Today's Humor..

    Luis Cazares (7/30/2014)

    Don't forget to use NOLOCK hints on all your queries and never ever run DBCC CHECKD, update statistics or rebuild indexes. You might encounter a lot of objects...

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

    July 31, 2014 at 5:19 pm

    #1734313

  • RE: Are the posted questions getting worse?

    Sean Lange (7/31/2014)

    Jeff Moden (7/31/2014)

    Sean Lange (7/31/2014)

    Jeff Moden (7/31/2014)

    Doug J. (7/31/2014)

    Jeff-

    This:

    Steve Jones - SSC Editor (7/31/2014)

    Just dropped over to the Heap Consultancy and I see a comment from Bill 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)

    July 31, 2014 at 5:03 pm

    #1734311

  • RE: Are the posted questions getting worse?

    swasheck (7/31/2014)

    Sean Lange (7/31/2014)

    Jeff Moden (7/31/2014)

    Doug J. (7/31/2014)

    Jeff-

    This:

    Steve Jones - SSC Editor (7/31/2014)

    Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about 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)

    July 31, 2014 at 5:00 pm

    #1734310

  • RE: Are the posted questions getting worse?

    Sean Lange (7/31/2014)

    Jeff Moden (7/31/2014)

    Doug J. (7/31/2014)

    Jeff-

    This:

    Steve Jones - SSC Editor (7/31/2014)

    Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring...

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

    July 31, 2014 at 3:02 pm

    #1734277

  • RE: Are the posted questions getting worse?

    Doug J. (7/31/2014)

    Jeff-

    This:

    Steve Jones - SSC Editor (7/31/2014)

    Just dropped over to the Heap Consultancy and I see a comment from Bill in KC about me staring at him from 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)

    July 31, 2014 at 1:37 pm

    #1734245

  • RE: Are the posted questions getting worse?

    swasheck (7/31/2014)

    To qualify my statement, I have no personal context for anything involving Jeff Moden and I'd welcome him. I've only perused SSC forums in the past and have just...

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

    July 31, 2014 at 12:53 pm

    #1734229

  • RE: Are the posted questions getting worse?

    autoexcrement (7/30/2014)

    How about "crap answers only"?

    Heh... maybe that would make a good alternative to "The Thread". 😀

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

    July 30, 2014 at 8:16 pm

    #1733899

  • RE: Importing Poorly Formatted Text File

    marg 14154 (7/20/2014)

    Jeff Moden (7/18/2014)

    Ed Wagner (7/18/2014)

    Jeff Moden (7/17/2014)

    Ok. Here we go. Time for some good ol' fashioned "Black Arts". 🙂

    The first thing is, is to understand 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)

    July 30, 2014 at 7:53 pm

    #1733898

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/30/2014)

    Steve Jones - SSC Editor (7/30/2014)

    Lynn Pettis (7/30/2014)

    It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when...

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

    July 30, 2014 at 6:27 pm

    #1733882

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/30/2014)

    Lynn Pettis (7/30/2014)

    It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try...

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

    July 30, 2014 at 6:26 pm

    #1733881

  • RE: Cross Join Help

    dwilliscp (7/30/2014)

    Do you have a good link for "Triangular" join, never heard of it.

    The author 😀 of the article at the following link has put it pretty simply although it'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)

    July 30, 2014 at 6:09 pm

    #1733878

  • RE: Do you usually go to agencies?

    Lynn Pettis (7/30/2014)

    SQL Guy 1 (7/30/2014)

    For instance, when you hear or read ASP what comes to your mind?

    Active Service Pages

    Application Service Provider

    Also googled:

    Appalachia Service Project

    Association of Software...

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

    July 30, 2014 at 12:46 pm

    #1733763

  • RE: Are the posted questions getting worse?

    Although I don't believe monitors should shut down the proverbial "teach a man to fish" type of responses, there are a large number of times that even a totally undocumented/no-writeup-included...

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

    July 30, 2014 at 12:31 pm

    #1733755

Viewing 15 posts - 23,011 through 23,025 (of 59,067 total)