Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 7,164 total)

  • RE: Data in tthe same order in which it is inserted

    He may not have believed you because you only gave him a partial solution. As the OP explained they had experienced, after only adding an identity column to the table...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 9:08 pm

    #1467267

  • RE: load data and foreign keys

    Z1024 (3/30/2012)

    opc.three (3/30/2012)

    Z1024 (3/29/2012)

    For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows from...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 8:01 pm

    #1467260

  • RE: Data in tthe same order in which it is inserted

    pietlinden (3/30/2012)

    Jeff,

    I thought I said that... maybe he didn't believe me. :hehe:

    (Believe me now?)

    Said what?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 7:52 pm

    #1467259

  • RE: Data in tthe same order in which it is inserted

    capn.hector (3/30/2012)

    PaulB-TheOneAndOnly (3/30/2012)

    opc.three (3/30/2012)

    The only way to ensure the data is not scrambled when inserting into a table is to reduce the "bacth commit size" to 1. Whether bcp, SSIS...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 4:27 pm

    #1467241

  • RE: Data in tthe same order in which it is inserted

    Jeff Moden (3/30/2012)

    As a side bar, it's always amazed me that people find importance in the order of the data in a file without actually having something in the file...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 4:25 pm

    #1467240

  • RE: Data in tthe same order in which it is inserted

    Matt Miller (#4) (3/30/2012)

    Lynn Pettis (3/29/2012)

    pietlinden (3/29/2012)

    add an incrementing identity column to the destination table before running inserts?

    And then when you select from the table be sure to use an...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 4:21 pm

    #1467239

  • RE: FK referencing PK in *same* table

    Very common in an adjacency list.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 12:43 pm

    #1467143

  • RE: a bunch of data flow tasks, how are they generated?

    Probably not a batch process...more likely copy/paste. You can copy Data Flow tasks, and then paste them back to the same Control Flow surface to gain a complete copy. If...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 12:23 pm

    #1467128

  • RE: Stored Procedure Error

    Dash is not supported character in object names, without escaping, so if it is dbo then try it like this

    dbo.[member-update]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 12:21 pm

    #1467126

  • RE: Stored Procedure 100% CPU During Data Insert, Manually Processing OK

    It could be a lot of things, but it sounds like parameter sniffing, i.e. a bad execution plan.

    Have you tried comparing the actual execution plans from the query causing trouble...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 11:35 am

    #1467113

  • RE: SSIS failed because low in memory

    sqlfriends (3/30/2012)

    Also if that's OK not to reboot the server after changing the memory setting?

    To answer this too, yes, you can change the max memory without rebooting. However, a reboot...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 11:15 am

    #1467102

  • RE: SSIS failed because low in memory

    sqlfriends (3/30/2012)

    Thank you, sorry it is kind of hard to understand the memory configuration.

    But from what paul.knibbs said to set to max 2.5 GB, but opc.three said to set it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 11:11 am

    #1467100

  • RE: load data and foreign keys

    capn.hector (3/30/2012)

    here in my shop we have a history table that we have no PK on. we just have FK's to the pertinent data and just insert to it.

    since...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 10:59 am

    #1467095

  • RE: load data and foreign keys

    wendy elizabeth (3/30/2012)

    This history table will have one index based upon an identity column and 2 rows that are foreign keys to two other tables. there will be about 4,000...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 10:43 am

    #1467086

  • RE: load data and foreign keys

    Z1024 (3/29/2012)

    For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows from a heavily...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 30, 2012 at 10:38 am

    #1467083

Viewing 15 posts - 4,666 through 4,680 (of 7,164 total)