Forum Replies Created

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

  • RE: How do I loop through rows and populate data?

    thejordans21 (8/1/2014)

    Here is my data.. (I have around 195K of rows)

    Here is a brief snapshot of it:PLANTPLANT_DESCVENDOR

    NOPENULLNOPE

    7010Coquitlam DCPR1

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULL1014435

    NOPENULL1014435

    NOPENULL1014435

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULL1014435

    NOPENULL1014435

    NOPENULL1014435

    What I need to happen is that where...

    --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 2, 2014 at 12:27 am

    #1734575

  • RE: Get next primary key without identity

    tshad (7/31/2014)

    I have a table to store int primary keys. Where the value nextID is the value to use.

    I need to get the value and update it (nextID +...

    --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 2, 2014 at 12:14 am

    #1734573

  • RE: Importing Poorly Formatted Text File

    Ah... scratch one of those questions. I see that the first section has quite a few extra line types. I do, however, still need to know if 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)

    August 1, 2014 at 11:25 pm

    #1734571

  • 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

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