Forum Replies Created

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

  • RE: how to split following string

    Steve Jones - Editor (2/18/2009)

    5 days is plenty. Sorry, missed the OP date.

    I'm interested to see the benchmarks. I know doing this in C would be complicated, but not tremendously...

    --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 18, 2009 at 9:04 pm

    #946453

  • RE: how to split following string

    Steve Jones - Editor (2/17/2009)

    Give him or her time, might be on the other side of the world.

    If you compare REVERSE with SUBSTRING or other string functions, how much slower...

    --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 18, 2009 at 6:42 am

    #945847

  • RE: The Value of Your Time

    ... and if you can't trust them, you probably hired the wrong person and should spend more time on personnel evals and the firing process than approving travel for someone...

    --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 10:42 pm

    #945672

  • RE: Do I need to index this table?

    Ah... another "tweek"....

    WHERE EmployeeID IS NOT NULL is a bit slower than WHERE EmployeeID > 0 assuming, of course, that you have no EmployeeID's <= 0... sometimes, quite 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)

    February 17, 2009 at 10:33 pm

    #945669

  • RE: Do I need to index this table?

    Lynn's suggested changes are a great way to start. What he failed to mention is... why. Even if you added a pot wad of indexes to the original...

    --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 10:30 pm

    #945667

  • RE: Guest editorial: SQL Code Metrics

    p.s. ... and we did it without {gasp} tool tips in SQL. Yes, there are some grand improvements that could be made to SQL, but we've seen 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)

    February 17, 2009 at 10:17 pm

    #945664

  • 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

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