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 » Best Practices » Performance » Distributed joi... » Query Processing   (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
Privacy Statement