Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have two SQL serves one is SQL server 2005 and other SQL server 2008.I push data from SQL server 2005 to SQL server 2008 using Linked Server.I want to improve performance of data transfer. 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. I don't remember that command .Guys can you please help me to find out this command.I check with MSDN site but no help.

Also if you have any other performance improvement tricks please let me know.

Thanks in advance...

share|improve this question

migrated from stackoverflow.com Dec 6 '13 at 7:34

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 0 down vote accepted

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 !!

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.