I see you have asked the same question at: Performance improvement in linked server-Disable data type check

I push data from SQL server 2005 to SQL server 2008 using Linked Server.I want to improve performance of data transfer.

Highly recommend to use SSIS. Linked servers are not meant to push data. Also, depending on the amount of data you are pushing or pulling (direction matters!!), the performance of linked server will always be slow + the n/w bandwidth plays an important role as well.

Refer to my answer for : Which one is more efficient: select from linked server or insert into linked server?

Few days back I cam across one article (I don't remember exact site name) which mentioned while inserting data in remote server you can disable data type check which can improve performance.He had mentioned one Set Command.

AFAIK, there is no such command in SQL Server to disable data type check which improves performance !!

I see you have asked the same question at: Performance improvement in linked server-Disable data type check

I push data from SQL server 2005 to SQL server 2008 using Linked Server.I want to improve performance of data transfer.

Highly recommend to use SSIS. Linked servers are not meant to push data. Also, depending on the amount of data you are pushing or pulling (direction matters!!), the performance of linked server will always be slow + the n/w bandwidth plays an important role as well.

Refer to my answer for : Which one is more efficient: select from linked server or insert into linked server?

Few days back I cam across one article (I don't remember exact site name) which mentioned while inserting data in remote server you can disable data type check which can improve performance.He had mentioned one Set Command.

AFAIK, there is no such command in SQL Server to disable data type check which improves performance !!