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 (15 total posts)
  • Speaking in Raleigh NC June 15th

    Just a heads up to those in the area that I will be speaking at the (TriPASS) Raleigh SQL Server user group on the 15th of June 2010. The topic is Storage & I/O Best Practices. The abstract is listed below: SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 2, 2010
  • Speaking at Best Practices in DC Next Month

    While I have been speaking about Best Practices for years this is the first time that I will speak at an actual Best Practices conference :).  I have 3 sessions entitled: SQL Server Configuration Best Practices Storage and I/O Best Practices for SQL Server Performance Monitoring Best Practices for SQL Server and I am actually ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 9, 2009
  • 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
Privacy Statement