Browse by Tags

• Architecture
• Bad database practices
• Best Practices
• Distributed join
• Linked server
• Performance
• Query Processing
• Security

• 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 Read More... Posted Tuesday, November 23, 2010 12:58 AM by Linchi Shea | 8 Comments Filed under: Performance, Best Practices, Query Processing, Distributed query, Linked server, Distributed join

• Bad database practices: moving data to procedures vs. moving procedures to data

  Is it better to move data to procedures or move procedures to data? The answer is, of course, “it depends.” Let’s consider a scenario where you have two SQL Server instances: ServerA and ServerB, and you have a procedure on ServerB (call it procB), but Read More... Posted Friday, October 30, 2009 1:00 AM by Linchi Shea | 2 Comments Filed under: Performance, Architecture, Best Practices, Distributed query, Linked server, Bad database practices

• 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 Read More... Posted Tuesday, July 21, 2009 2:16 PM by Linchi Shea | 22 Comments Filed under: Performance, Query Processing, Security, Distributed query, Linked server, Distributed join