Forum Replies Created

Viewing 15 posts - 35,401 through 35,415 (of 59,099 total)

  • RE: UPDATE using a self-join

    GSquared (1/13/2011)[hrUpdate From can have problems if it runs into two or more rows that match the Join/Where criteria and would update one row in the target table. Same...

    --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 13, 2011 at 8:03 am

    #1273067

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    I think that green is an appropriate color for the US

    It would be nice if they kept them Green. Have you seen how much...

    --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 12, 2011 at 9:07 pm

    #1272782

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/12/2011)

    As my friend Jeff would say, Bwaa-haa-haa

    BWAA-HAAA!!!! Now THAT's some funny stuff right there. Thanks for the laugh, Steve! 🙂

    --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 12, 2011 at 9:00 pm

    #1272780

  • RE: substring funcation.

    mister.magoo (1/12/2011)

    While we are offering alternatives to the missing function, in this case why not use the xml facilities available?

    DECLARE @exampleString xml

    SET @exampleString = ' <result>failure</result> <reason>invalid Phone1</reason> <leadId>xxxxxxxxxxxx</leadId> <url><![CDATA[https://blahblahblah]]></url>...

    --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 12, 2011 at 8:57 pm

    #1272779

  • RE: Creating a comma-separated list (SQL Spackle)

    WayneS (1/12/2011)

    Jeff Moden (1/12/2011)

    Very cool! Wayne writes an excellent article, Mark provides an excellent performance enhancement in the discussion, and Wayne tests it for everyone. It doesn't get...

    --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 12, 2011 at 8:51 pm

    #1272778

  • RE: Creating a comma-separated list (SQL Spackle)

    WayneS (1/12/2011)

    Mark-101232 (1/12/2011)

    Changing

    value('.','varchar(max)'),1,1,'')

    to

    value('(./text())[1]','varchar(max)'),1,1,'')

    appears to give a better query plan

    Thanks for the information... I'll have to test this out.

    Edit: WOW! What a difference!...

    --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 12, 2011 at 5:54 pm

    #1272753

  • RE: UPDATE using a self-join

    CELKO (1/12/2011)

    Using BIT is bad and a NULL bit makes no sense. Using the proprietary UPDATE..FROM.. syntax has lots of problems with cardinality and portability.

    I don't care about portability but...

    --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 12, 2011 at 4:37 pm

    #1272726

  • RE: substring funcation.

    BaldingLoopMan (1/11/2011)

    I don’t really need help parsing the data. I was just purposing a question. Why is there no substring function that has a starting position and ending position as...

    --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 12, 2011 at 4:26 pm

    #1272718

  • RE: Temporary variables in SQL

    Also, table variables don't necessarily make things any faster than a Temp Table. They both start out in memory... they both write to disk (TempDB) when they get bigger...

    --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 12, 2011 at 7:16 am

    #1272351

  • RE: How to determine first valid enrollment date

    Heh... it's not as easy as it looks, huh?

    Thank you for setting up the sample data correctly. This should do it for you... the CTE's are named after what...

    --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 11, 2011 at 7:42 pm

    #1272160

  • RE: MCITP advice

    david.alcock (1/11/2011)

    ...and a hello as well to everyone.

    I passed my 070-431 yesterday, absolutely delighted.

    My question is about the upgrade MCITP exam. Im hoping to do 443 &...

    --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 11, 2011 at 7:19 pm

    #1272152

  • RE: Recursive Query to SSIS steps from Raw Data Source

    zahidullislam (1/11/2011)

    Hello,

    Can anyone please help me to (Pseudocode will be perfect) to translate below query to SSIS steps?

    My Data Source is is Raw file and output will be in Raw...

    --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 11, 2011 at 7:17 pm

    #1272150

  • RE: updating a column

    tfifield (1/11/2011)

    Jeff Moden - 1/10/2011

    Why can't you just add the IDENTITY property to the UNQ_ID column? It will help you avoid a whole lot of headaches including but certainly not...

    --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 11, 2011 at 6:52 pm

    #1272149

  • RE: require additional memory?

    Also (just and FYI), during INSERTs, it could also be too many indexes or an index with extremely low cardinality. For example, any index where the first column has...

    --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 11, 2011 at 6:36 pm

    #1272148

  • RE: User Defined Roles

    Lowell,

    If you want to "continue the tradition" on these short articles, please feel free to use the "SQL Spackle" idea and the quote from "Phil McCraken". I've found 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 11, 2011 at 9:59 am

    #1271957

Viewing 15 posts - 35,401 through 35,415 (of 59,099 total)