Forum Replies Created

Viewing 15 posts - 49,006 through 49,020 (of 59,093 total)

  • RE: DTS - How would I achieve this?

    s_chilkury (8/1/2008)

    I want this to be resolved using DTS only.

    Why?

    --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, 2008 at 8:19 pm

    #852266

  • RE: large database with millions of querys

    gtobee (7/25/2008)

    looking to see if anyone is running a 10T MS SQL database.

    Why? What's the problem?

    --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, 2008 at 8:17 pm

    #852265

  • RE: Beat this - comic relief for the day

    Heh... c'mon now... {clutching sides in laughter... almost fell out of chair}, that developer is doing the best (s)he can...

    Thanks for the Friday laugh...

    Steve, you should start 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)

    August 1, 2008 at 8:14 pm

    #852264

  • RE: Datatype in CTE

    This is why we always ask for a description of what you're trying to do... are you trying to generate 12 otherwise identical rows for each employee 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)

    August 1, 2008 at 8:09 pm

    #852263

  • RE: Stored Procedures Reconsidered

    Matt Miller (8/1/2008)

    As long as you're not hung up on performance, then cursors must be fine, since they help with readability...hmm no, not really, since they add more useless 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)

    August 1, 2008 at 7:51 pm

    #852258

  • RE: Can't debug CLR locally

    MichaelC (8/1/2008)

    Thanks Jeff! I'll play with these too. I think you also posted some suggestions when I was working with this function a while back, but we thought...

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

    #852257

  • RE: Can't debug CLR locally

    Jonathan Kehayias (8/1/2008)

    Hmm, I have to go play with your code now Jeff. I am not surprised that you once again replaced a loop with a Tally/Numbers 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)

    August 1, 2008 at 7:19 pm

    #852255

  • RE: Analytical Interview Questions

    michael.agarwal (8/1/2008)

    Here is another puzzle:

    There are 10 stacks of coins. Each stack contains 10 coins. All coins look same. All coins weigh 0.1 lb in 9 stacks but in one...

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

    #852250

  • RE: Using PATINDEX to find all numeric values

    Sean Peters (7/31/2008)

    No IsNumeric('11,22,33') = 1

    Ummm... nope... it isn't...

    SELECT ISNUMERIC('11,22,33')

    -----------

    0

    (1 row(s) affected)

    I will agree, though, that...

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

    #852249

  • RE: LEFT JOIN vs EXCEPT

    Christopher Stobbs (8/1/2008)

    Jeff,

    How would you best two queries to see which is performing better?

    thanks

    Chris

    One way is already demonstrated in the code I posted previously in this thread. Another way...

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

    #852247

  • RE: LEFT JOIN vs EXCEPT

    rbarryyoung (8/1/2008)

    jcrawf02 (8/1/2008)

    By the way, it's very big of you to contribute to the same thread as Jeff, when he's obviously anti-RBARry, but just can't spell your name . ....

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

    #852244

  • RE: Can't debug CLR locally

    Jonathan Kehayias (8/1/2008)

    Jeff is looking to find out what you are trying to use CLR for. If it is just string splitting, unless you are using extremely long strings, that...

    --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, 2008 at 5:57 pm

    #852243

  • RE: Can't debug CLR locally

    ... and, heh... no "debug" is required on those... 😀

    --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, 2008 at 5:56 pm

    #852242

  • RE: Can't debug CLR locally

    Michael,

    Although using a WHILE loop to split a string is a tried and true method, it's relatively slow compared to other methods. Please see the following two articles... they're...

    --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, 2008 at 5:55 pm

    #852241

  • RE: Stored Procedures Reconsidered

    Manie Verster (8/1/2008)

    What is everybody's problem with cursors! How many articles do I still have to read where people talk about how bad cursors are! What is the difference 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)

    August 1, 2008 at 5:26 pm

    #852238

Viewing 15 posts - 49,006 through 49,020 (of 59,093 total)