Explore our sites

Stack Exchange
tour help
Tell me more ×
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.
up vote 1 down vote favorite

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
add comment

migrated from stackoverflow.com 23 hours ago

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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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