THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Distributed join   (RSS)
  • Linked servers: permissions and distributed query performance

    In 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 Online for SQL Server 2008 R2,  Microsoft has revised the documentation, and included the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 22, 2010
  • Bad database practices: abusing linked servers

    In 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 your data or even how you get the data as long as you can use them to further compose a set-based ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 6, 2009
  • Performance impact: Linked server security configuration and how it can hurt you

    If 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 from the remote table referenced in the query?   Many people probably would answer no. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 21, 2009
Privacy Statement