Linchi Shea : Security, Distributed join, Linked serverhttp://sqlblog.com/blogs/linchi_shea/archive/tags/Security/Distributed+join/Linked+server/default.aspxTags: Security, Distributed join, Linked serverenCommunityServer 2.1 SP2 (Build: 61129.1)Performance impact: Linked server security configuration and how it can hurt youhttp://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">PerformanceQuery ProcessingSecurityDistributed queryLinked serverDistributed join