http://sqlblog.com/blogs/linchi_shea/archive/tags/Distributed+query/Distributed+join/Linked+server/default.aspxTags: Distributed query, Distributed join, Linked serverenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2010/11/23/linked-servers-permissions-and-distributed-query-performance.aspxTue, 23 Nov 2010 04:58:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:30897Linchi Shea8http://sqlblog.com/blogs/linchi_shea/comments/30897.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=30897In an earlier post , I highlighted that linked server security configuration can have a huge performance impact, and complained that this was not properly documented in SQL Server Books Online and filed a Connectitem for this. Good news is that in Books...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/11/23/linked-servers-permissions-and-distributed-query-performance.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=30897" width="1" height="1">Best PracticesDistributed joinDistributed queryLinked serverPerformanceQuery Processinghttp://sqlblog.com/blogs/linchi_shea/archive/2009/07/21/performance-impact-linked-server-security-configuration-and-how-it-can-hurt-you.aspxTue, 21 Jul 2009 17:16:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15387Linchi Shea22http://sqlblog.com/blogs/linchi_shea/comments/15387.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=15387If you change the security configuration of a linked server from using login UserA to login UserB, would you expect that to significantly impact the performance of a query that uses the linked server, assuming that both users have permission to select...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2009/07/21/performance-impact-linked-server-security-configuration-and-how-it-can-hurt-you.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=15387" width="1" height="1">Distributed joinDistributed queryLinked serverPerformanceQuery ProcessingSecurity