Post reply

Fastest Way to copy a fields table to table in SP

  • October 30, 2003 at 1:52 pm

    #106902

    I was wondering, if i got fields in table A wanted to do some transformation and copy it to table B, what is the fastest way in a store procedure? i have to do

    insert into B

    select field1

    , field2

    etc.

    from A

    do i suppose to enable "select into / bulk copy" for faster performance? or in a database properties i have already put simple as logging, instead of full and select into/bulk copy..

    which one perform more logging ? select into / bulk copy or simple???????

    Edgar

  • October 30, 2003 at 2:50 pm

    #480371

    If your recovery model is already set to SIMPLE then I would stay with the insert command and do your transformations in the select statement. If you need to empty the table before inserting then use the truncate table statement. (“The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table”)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply