THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Best Practices » Performance » Bad database practices   (RSS)
  • 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
  • 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 need to access data on ServerA.   Three database solutions are ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 30, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement