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 » Performance » Best Practices » Architecture   (RSS)
  • 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
  • Best and Worst Checkpoint Performance

    The best documentation on the I/O behavior of SQL Server checkpoints is found in SQL Server 2000 I/O Basics by Bob Dorr. In particular, you should read the following carefully: SQL Server uses the following steps to set up another page for flushing and repeats for up to 16 total pages inclusive of the first page. Do a hash lookup for the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 1, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement