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 Paractices   (RSS)
Showing page 2 of 2 (13 total posts)
  • Cleaning up Un-Named Defaults

    I just had a situation in which we are automating the comparing of databases and I came across a bunch of Defaults that were never explicitly named. This causes them to get a new name each time you create them and makes it much more difficult to write future update scripts when you don’t know the actual name it will be. In any case I decided to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 26, 2009
  • How Dirty are your Reads?

    As a SQL Server consultant I get to see a lot of different sets of code written by all sorts of database developers from all over the world. And I have to say that one thing that is clear is most developers make abundant use of the NOLOCK query hint or the READ UNCOMMITTED isolation level. Now don’t get me wrong, I am NOT trying to say this is bad ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on April 10, 2009
  • Getting back to the basics with I/O

           One of the most common trends that I see related to performance & scalability with SQL Server is a poorly configured or implemented storage subsystem. There is a ton of information out there on this subject but in my opinion that is part of the problem.  Too much data is not always a good thing and there ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 13, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement