Forum Replies Created

Viewing 15 posts - 58,486 through 58,500 (of 59,091 total)

  • RE: best way to copy active table

    Like I said earlier... the hard knocks code will beat the pants off DTS either way.  Thanks for the feedback Greg.  You can get some extra performance out of SELECT...

    --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, 2006 at 8:20 pm

    #615681

  • RE: Eliminating Cursors

    >>>These temp tables can then be cursored...

    I don't think you understood... the whole idea is to get rid of cursors and other RBAR methods in SQL Server.

    --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, 2006 at 7:37 pm

    #615678

  • RE: Eliminating Cursors

    >>But for this type of operation, I still think xp_execresultset is the best solution.

    The original post was for "Eliminating Cursors" so I have to ask... how do you use 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 18, 2006 at 7:34 pm

    #615677

  • RE: Eliminating Cursors

    Just my humble opinion but I need to clear up some of the myths associated with Table Variables...

    First, table variables don't live in memory anymore than temp tables...

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

    #615451

  • RE: Column data to separate rows

    Thanks for coming back, John...

    Yeah, I saw your original post where you said you had a table with all of the individual possible values.  Your solution looks as though 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 17, 2006 at 8:08 pm

    #615356

  • RE: best way to copy active table

    Greg,

    I don't know if having the Primary Key on the last column will affect performance especially for CLUSTERED keys... I'd have to study the format in BOL a bit.

    However,...

    --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, 2006 at 7:48 pm

    #615354

  • RE: best way to copy active table

    Gail,

    You wrote "ps, I don't understand your comment about pushing into a table without a pk. Best insert performance is a when inserting into a heap with no indexes".

    Normally 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 17, 2006 at 7:45 pm

    #615353

  • RE: best way to copy active table

    Then something else went wrong, Gail.  Perhaps there was a cross-join in the code.  Perhaps you had a bad connection (it happens).  Perhaps the linked server was not setup correctly. ...

    --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, 2006 at 5:48 am

    #615106

  • RE: Execution plans

    Not sure why that would matter at all but OK, whatever you say.  I was thinking that maybe the servers had some different settings (like collation and memory allocation), 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 16, 2006 at 9:22 pm

    #615046

  • RE: copying from one database to another - but only new data?

    Uh... if you're new, it'll take a bit of study on your part, but you may want to consider setting up "replication"... then, it's nearly "auto-magic" from there.  The steps...

    --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 16, 2006 at 9:10 pm

    #615044

  • RE: best way to copy active table

    Well, thanks Greg.  I'm thinking that 35 seconds including the addition of a Primary Key isn't too bad (1.37 million rows per minute).  I love it when DTS looses (and 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 16, 2006 at 9:04 pm

    #615043

  • RE: Synchronising Databases

    If you truly want to synchronize, why not just generate all the code for sprocs, views, and udf's in Enterprise Manager and let 'er rip?

    --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 16, 2006 at 8:44 pm

    #615042

  • RE: Column data to separate rows

    Ok, then... you ask a question, I bust a hump giving you a pretty good answer... did it work for you or 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 16, 2006 at 8:42 pm

    #615041

  • RE: Text Parsing TSQL code

    Milovan,

    I noticed that all of the other solutions, although well written and functional, contain WHILE loops.  Inherently, WHILE loops are slower than setbased code especially if you have a lot...

    --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 16, 2006 at 8:13 pm

    #615038

  • RE: Bulk Insert flatfile question

    To do this, you will need a BCP format file OR, lose the IDENTITY column.  BCP Format files can actually do all of the parsing in the final format 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)

    January 16, 2006 at 7:32 pm

    #615035

Viewing 15 posts - 58,486 through 58,500 (of 59,091 total)