Forum Replies Created

Viewing 15 posts - 45,091 through 45,105 (of 59,095 total)

  • RE: Guest editorial: SQL Code Metrics

    I read the last paragraph with mixed thoughts on the subject of code metrics. I started playing back in my mind what many Developers do if left to their...

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

    February 17, 2009 at 9:55 pm

    #945657

  • RE: Optimize BCP

    4DJ**** (2/17/2009)

    simple recovery mode will still write to log file. but in bulklogged recovery model, these type of operations are not logged at all. so saveing time on IO, CPU...

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

    February 17, 2009 at 9:18 pm

    #945644

  • RE: Developer asked a cursor question

    Luke L (2/17/2009)

    I'll toss another on the pile recommending a set based solution. This seems like a perfect teaching/mentoring moment. At the very least she should be commended...

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

    February 17, 2009 at 9:08 pm

    #945638

  • RE: Developer asked a cursor question

    Matt Miller (2/17/2009)

    I would just turn around and ask her to tell you why it HAS to be one row at a time. If it seems to come across...

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

    February 17, 2009 at 8:57 pm

    #945632

  • RE: third party applications that Block Block Block and Deadlock

    Yeah... I went through such hell with a 3rd party POS myself. In my case, it had no archiving and, worse, it used a Sequence Table instead of IDENTITY...

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

    February 17, 2009 at 8:32 pm

    #945625

  • RE: T SQL Training / CBT

    Nothing free... just beginner stuff.

    If you really want to "take it to the next level", I know a pretty good forum that you could start answering questions 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)

    February 17, 2009 at 7:59 pm

    #945620

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (2/17/2009)

    Jeff Moden (2/17/2009)

    I agree... especially when the someone who writes the document is really a frustrated novelist and includes no code samples. Or worse... incorrect code...

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

    February 17, 2009 at 7:46 pm

    #945619

  • RE: Are the posted questions getting worse?

    Bob Hovious (2/17/2009)

    P.S.

    I send IMs to the guys in the next cube all the time... you can cut and paste code, or whatever, and not bother all the other folks...

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

    February 17, 2009 at 7:43 pm

    #945618

  • RE: Are the posted questions getting worse?

    Bob Hovious (2/17/2009)

    "correlated sub-query"

    Correlated sub-query?

    CorrELATed sub-query?

    No wonder I haven't been able to find anything !!!!!

    I've been trying to search for CORRUGATED subqueries !!!! :w00t:

    ---------------------------------------------------------------------------------------------

    Seriously, even reading...

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

    February 17, 2009 at 7:36 pm

    #945616

  • RE: SQL or Oracle

    Lynn Pettis (2/17/2009)

    Back to the topic at hand (at least for the moment). Both products have their place or else they both would not exist. Where I may...

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

    February 17, 2009 at 7:08 pm

    #945608

  • RE: Normalizing-Denormalized Tables

    Mohit (11/12/2008)

    Toni Thank-you for the suggestion :).

    I started working on the part-2 of this article, I will talk about all the suggestions in that article. If there are any...

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

    February 17, 2009 at 7:00 pm

    #945605

  • RE: How to store results for a query to a table?

    Chinesinho (2/17/2009)

    Jeff,

    The target table does already exist. I have tried running insert but that didn't work. So what am I missing? Thanks!

    Oh, my bad and...

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

    February 17, 2009 at 6:45 pm

    #945604

  • RE: how to split following string

    Jeff Moden (2/13/2009)

    DURGESH (2/13/2009)

    hi all,

    i have a string as 'a;b;cde;f;ghi;d' or 'a;b;cde;f;ghi;defg'

    now i want to split the given string as 'a;b;cde;f;ghi;' or 'a;b;cde;f;ghi;'

    i tried using substring,left,charindex functions but i...

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

    February 17, 2009 at 6:38 pm

    #945600

  • RE: how to split following string

    Gopi Nath Muluka (2/17/2009)

    Another version, assumes that data should be removed after last delimiter

    CREATE TABLE TTT

    (

    ID INT IDENTITY (1,1) NOT NULL,

    ...

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

    February 17, 2009 at 6:36 pm

    #945599

  • RE: How to add cost percentage to product

    AFCC Inc. Com (2/17/2009)

    What I am doing is creating a table that has one row, and this row contains the WidthTo columns

    Then I create a HeightTable and this table contains...

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

    February 17, 2009 at 6:33 pm

    #945598

Viewing 15 posts - 45,091 through 45,105 (of 59,095 total)