http://sqlblog.com/blogs/linchi_shea/archive/2009/11/06/bad-database-practices-abusing-linked-servers.aspxIn SQL Server, it is rather handy to retrieve data from a different SQL Server instance and use the result locally in another SQL statement for further processing. In theory and in the set purists’ fantasy land, it shouldn’t matter where you get yourenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2009/11/06/bad-database-practices-abusing-linked-servers.aspx#19131Tue, 24 Nov 2009 02:41:45 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19131Vijaya Kadiyala<p>Its good information. At the first place is it good to have Linked servers?</p> http://sqlblog.com/blogs/linchi_shea/archive/2009/11/06/bad-database-practices-abusing-linked-servers.aspx#19403Wed, 02 Dec 2009 04:19:08 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19403Linchi Shea<p>Vijaya;</p> <p>In general, linked servers are an extremely useful tool for accessing data among the SQL instances, and in a distributed environment, you can expect data to be 'distributed' among different servers.</p> http://sqlblog.com/blogs/linchi_shea/archive/2009/11/06/bad-database-practices-abusing-linked-servers.aspx#35697Wed, 18 May 2011 02:59:38 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35697Michelle Jenks<p>Recently a Microsoft employee stated that linked servers should not be used, and to add that to our best practices. &nbsp; I did not hear what he said as so black and white, but others in my company did. &nbsp;Your thoughts?</p>