Forum Replies Created

Viewing 15 posts - 40,201 through 40,215 (of 59,072 total)

  • RE: Perfect is the Enemy of Good

    p.s. Andy, that's not directed at you or anyone in particular. You just happened to hit a "sweet" spot (or is that "sweat" spot :-P) with me. ...

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

    January 19, 2010 at 9:47 pm

    #1105818

  • RE: Perfect is the Enemy of Good

    I agree that "perfect" is sometimes the enemy of the "good"...

    ...but that's usually just some garbage excuse by people who don't really care to begin with. Think about it......

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

    January 19, 2010 at 9:32 pm

    #1105815

  • RE: Perfect is the Enemy of Good

    roger.plowman (1/19/2010)

    GOC-481399 (1/19/2010)

    Be good to see an alternative article on how to maintain your standards when thrown into a (purely hypothetical of course) BI/Reporting team where:

  • Nothing is documented...

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

January 19, 2010 at 8:49 pm

#1105808

  • RE: Knowledge Transfer

    george sibbald (1/18/2010)

    access methods and passwords

    Allow me to emphasize what George said above... make darned sure you have ALL the SA and DBA passwords! If this person leaving also...

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

    January 19, 2010 at 8:43 pm

    #1105806

  • RE: Knowledge Transfer

    Steve Jones - Editor (1/18/2010)

    And buy him a few lunches. That will go a long way when you call later.

    If (s)he is a person who likes to occasionally imbibe, 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)

    January 19, 2010 at 8:35 pm

    #1105805

  • RE: identity column using opendatasource

    BWAA-HAA! Finally! I read a whole post before jumping in! 😀 Nicely done, John.

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

    January 19, 2010 at 8:33 pm

    #1105804

  • RE: Pivot table

    The Dynamic Crosstab article that Lutz mentions above very specifically has a "year long" example that should do the trick for you. All you have to do is change...

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

    January 19, 2010 at 8:31 pm

    #1105803

  • RE: Split SP input

    Thought I'd throw a different slant on that and also add a couple of optimizations for both VARCHAR(8000) and single character delimiters...

    CREATE FUNCTION dbo.DelimitedSplit

    /**************************************************************

    Purpose:

    Split a given string...

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

    January 19, 2010 at 8:20 pm

    #1105802

  • RE: Strategies for bypassing the 8,060 byte limit on Row Length

    Just a clarification... use of NTEXT in 2k does NOT allow you to violate the 8060 rule. The data that's normally stored in the table is a numeric pointer...

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

    January 19, 2010 at 7:30 pm

    #1105793

  • RE: Caution with EXCEPT

    Thanks for the feedback and I hope you get well soon.

    As a side bar, if "total cost" is coming from the execution plan, then possibly a bad test. 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)

    January 19, 2010 at 6:07 pm

    #1105785

  • RE: Caution with EXCEPT

    Nicely done, Stephen. Well written and straight to the point.

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

    January 18, 2010 at 9:56 am

    #1105020

  • RE: Caution with EXCEPT

    jdurandt (1/18/2010)

    That's interesting

    I benchmarked EXCEPT vs WHERE NOT IN (SELECT .....), and for my dataset, server, DB version etc. the performance results were equivalent, or biased towards EXCEPT.

    Can you give...

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

    January 18, 2010 at 9:53 am

    #1105017

  • RE: Image column - How to put a where clause

    Now, there's an idea. Thanks, Remi.

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

    January 18, 2010 at 9:45 am

    #1105012

  • RE: updating 1,000 records takes 5-6 minutes I would like to decrease the time that takes

    Lynn Pettis (1/17/2010)

    Jeff Moden (1/17/2010)

    itsmeman (1/5/2010)

    This issue is done for now....

    Two way street here... please explain how this issue is "done for now".

    My guess, they ran the update 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)

    January 18, 2010 at 9:43 am

    #1105010

  • RE: Image column - How to put a where clause

    Sorry about that... that's why I only store file names for images.

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

    January 17, 2010 at 9:43 pm

    #1104783

    • Viewing 15 posts - 40,201 through 40,215 (of 59,072 total)