Forum Replies Created

Viewing 15 posts - 49,096 through 49,110 (of 59,099 total)

  • RE: Test Data

    Ah... I get it now... you want to test/compare every combination of 1 to 10 characters (36 characters total) of the old UDF against the new UDF. (3611)-1 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 23, 2008 at 8:33 pm

    #847489

  • RE: Executing Stored Procedure Vs. Code within procedure

    Thanks for the feedback...

    By the way, being a bit of a code formatting and documentation freak, I really like your tagline on your posts. 😉

    --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 23, 2008 at 7:52 pm

    #847483

  • RE: Dumb Question

    rbarryyoung (7/23/2008)

    1) Recovery: Audit table is supposed to serve as a means to reconstruct a pre-existing table/database. Audit table is stored in a different DB & disk or...

    --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 23, 2008 at 7:04 pm

    #847472

  • RE: xp_cmdshell

    Lester Policarpio (7/21/2008)

    Good Day,

    I want to ask how to troubleshoot this kind of problem. I'm handling many servers everyday (select, update, delete). I created...

    --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 23, 2008 at 6:34 pm

    #847466

  • RE: Executing Stored Procedure Vs. Code within procedure

    It may be operating off a bad cached plan... try the WITH RECOMPILE option in the stored procedure. It could also be "parameter sniffing"... lot's of articles available 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)

    July 23, 2008 at 6:20 pm

    #847465

  • RE: Test Data

    Lynn Pettis (7/23/2008)

    Does anybody have some code to build a table of strings from 1 to 10 characters in length, with no trailing or leading spaces (embedded spaces are allowed)...

    --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 23, 2008 at 6:16 pm

    #847464

  • RE: Dumb Question

    That scenario (like many) audits the wrong thing... you should only Audit the DELETED table... the current value is always in the original table.

    --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 23, 2008 at 7:49 am

    #847049

  • RE: Dumb Question

    GSquared (7/23/2008)

    you need the original data, or you can't track what was changed in the first update on a column.

    ??? I'm not sure why you say that! We...

    --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 23, 2008 at 7:28 am

    #847025

  • RE: Handling Tempdb space full situtation?

    GilaMonster (7/23/2008)

    On my main system, TempDB is 6 files of 8 GB each.

    Now THAT sounds like a fun system to be on and that the DBA (you, Gail?) might...

    --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 23, 2008 at 6:48 am

    #846985

  • RE: Handling Tempdb space full situtation?

    Ross McMicken (7/23/2008)

    The DBA's that specified the 50MB were of the opinion that aproperly designed application doesn't need more tempdb. I was glad I didn't have to deal with them....

    --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 23, 2008 at 6:45 am

    #846981

  • RE: UDF execution through a CLR

    Jonathan Kehayias (7/23/2008)

    Unless there is some amazingly complex operation happening that we haven't seen the code for, then this is misplaced.

    Heh... I think about 99% of all CLR code 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 23, 2008 at 6:39 am

    #846974

  • RE: Handling Tempdb space full situtation?

    Heh... 50MB for a TempDB... we start our TempbDB up at 12 Gig!

    --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 23, 2008 at 6:16 am

    #846954

  • RE: UDF execution through a CLR

    OK... maybe I'm missing something, but why would you want to do that with a CLR? :blink:

    --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 23, 2008 at 6:13 am

    #846949

  • RE: The IT Employee Benchmark

    Anirban Paul (7/23/2008)

    Certificate are easily earned but knowledge not. You have to work hard for knowledge not that hard for certificate. 🙂

    That pretty much summarizes my feelings about certificates...

    --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 23, 2008 at 6:09 am

    #846945

  • RE: The IT Employee Benchmark

    Wayne West (7/22/2008)

    The Code markup codes are also pretty cool. I'd like to know how people do the scrolling boxes, though. :hehe:

    Those are done using the "code" IFCodes... 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 23, 2008 at 6:08 am

    #846944

Viewing 15 posts - 49,096 through 49,110 (of 59,099 total)