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 » Documentation   (RSS)
  • Updated File & Wait Statistics Procedures

              For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some minor modifications that I want others to be aware of. Since many of you have received copies of the past revisions ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • White Paper on Parallel Processing

      I just ran across what I think is a newly published white paper on parallel  processing in SQL Server 2008 R2. The date is October 2010 but this is the first time I have seen it so I am not 100% sure how new it really is. Maybe you have seen it already but if not I recommend taking a look. So far I haven’t had time to read it ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 10, 2010
  • What time do you have?

    The way in which SQL Server has treated Time has been a very misunderstood subject for as long as I can remember. The largest part of that was the fact that SQL Server was only accurate to 3.33ms. I would like to point you to an excellent article on this and other details surrounding Datetime in SQL Server by Tibor Karaszi found here:  ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 20, 2008
  • 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