Forum Replies Created

Viewing 15 posts - 38,011 through 38,025 (of 59,072 total)

  • RE: Alter command

    Bhuvnesh (6/9/2010)

    @jeff

    Which would be the better option ?

    1. USE ALTER TABLE ....ALTER COLUMN approach

    2. Create new table and then push the exisitng table's data into it.

    and does...

    --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 10, 2010 at 7:30 am

    #1178590

  • RE: Primary Key Generation

    mike 57299 (6/9/2010)

    Jeff,

    What would you recommend to make sure I don't get duplicate primary keys? Should I do it as a standard proc?

    Mike

    I agree with Gail. Even...

    --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 10, 2010 at 7:18 am

    #1178584

  • RE: Is the MVP Worth It?

    James Stover (6/10/2010)

    I took the question to be if someone is actively seeking MVP status, rather than based on work they are already doing. Who gives a rat's a** if...

    --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 10, 2010 at 7:05 am

    #1178579

  • RE: Primary Key Generation

    It's not going to happen using a function because a function isn't allowed to update or insert into "real" tables... period.

    --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 9, 2010 at 11:17 pm

    #1178438

  • RE: Selecting the earliest month wrapping January to December

    bteraberry (6/8/2010)

    Jeff Moden (6/8/2010)

    Unless I'm missing something, this problem is impossible to solve because there's simply nothing to guarantee the order of the data. There has to be 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)

    June 9, 2010 at 11:14 pm

    #1178437

  • RE: get count from count query

    As a sidebar and extension of the problem... lookup WITH ROLLUP and WITH CUBE as associated with GROUP BY. Powerful tools there. 😉

    --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 9, 2010 at 11:06 pm

    #1178434

  • RE: Alter command

    pujain (6/9/2010)

    Hi All,

    i need to alter multiple column in from null to not null in production server.

    table have millions of records, and taking each alter is taking hours to run....

    --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 9, 2010 at 10:57 pm

    #1178431

  • RE: Alter command

    CirquedeSQLeil (6/9/2010)

    Two options

    Create a cursor that does essentially the same thing I just showed you.

    or

    Run that script, review the commands, and then set it up in a job to execute...

    --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 9, 2010 at 10:43 pm

    #1178424

  • RE: exclude one column

    Heh... drat... day late and a dollar short. I just saw what Grant already posted.

    --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 9, 2010 at 10:40 pm

    #1178422

  • RE: exclude one column

    tripri (6/9/2010)

    hi,

    i got a table with almost 20 columns. Now the problem is

    if i do

    Select * from table

    i will get all the wenty columns

    what if i want only 19...

    --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 9, 2010 at 10:39 pm

    #1178421

  • RE: Is the MVP Worth It?

    To answer the question of "Is the MVP Worth It?", the answer IMHO is absolutely "No". As someone previously noted on this thread, most good MVPs (and even some...

    --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 9, 2010 at 10:31 pm

    #1178417

  • RE: Is the MVP Worth It?

    GilaMonster (6/9/2010)

    Yes.

    Personally I lurk on forums, write blog posts and articles and present because I enjoy it, not because I'm paying dues or trying for an award. I'd be doing...

    --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 9, 2010 at 9:21 pm

    #1178403

  • RE: Is the MVP Worth It?

    blandry (6/9/2010)

    In over 30 years in this business, I have rarely seen anyone with an MVP award who actually measures up to being an "MVP" - and worse, in some...

    --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 9, 2010 at 9:19 pm

    #1178402

  • RE: Is the MVP Worth It?

    James Stover (6/9/2010)

    If I were to choose between putting in the hard yards for a MVP vs. MBA, I would absolutely go for the MBA. I also dare say there...

    --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 9, 2010 at 8:52 pm

    #1178398

  • RE: Splitting One Row Data into Two Rows

    Understood. You might want to look into the use of [0-9] and [^0-9] just to simplify the code a bit.

    Nicely done on the two row "embedded Tally Table" for...

    --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 9, 2010 at 8:26 pm

    #1178393

Viewing 15 posts - 38,011 through 38,025 (of 59,072 total)