performance

[gzm219]

In a sql70 stored procedure, I use command:
insert into <target_table> select * from <source_table> to isnert records to target table
but the target table is to very big and has many indexes, the operation is very slow. I recompile several times but still slow. How to improve? please help.

also, when move to sql2000, it much slower than in sql70. many stored procedures have the same results. why?

 

[ronnetp]

Maybe you can try with bcp with the query option or
also Bulk Insert

 

[gzm219]

Hi ronnetp: thank you. Can you tell me the commands for bcp or bulk insert. I only know bcp and bulk insert are for transferring data between data file and sql server, I don't know how to do between tables.
thanks

 

[ronnetp]

Check the query option

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_bcp_61et.asp