Forum Replies Created

Viewing 15 posts - 23,041 through 23,055 (of 59,099 total)

  • RE: Importing Poorly Formatted Text File

    Thank you for the feedback.

    Shifting gears to your latest and I have to ask, where did that particular file come from?

    Thinking about the problem at hand with that file, 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)

    August 1, 2014 at 11:18 pm

    #1734570

  • RE: Index and Page Split

    You could disable them which drops all of the data from the index but keeps the meta data and see if peformance suffers. Of course, you need 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)

    August 1, 2014 at 10:22 am

    #1734498

  • 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

Viewing 15 posts - 23,041 through 23,055 (of 59,099 total)