in

SQLServerCentral.com

The largest free SQL Server community.
All Tags » Performance Tuning (RSS)

Browse by Tags

  • DBA's Need (and Deserve!) a Large Monitor, and Preferably Two of Them

    With all the options we have for viewing query plans I still prefer the graphical view. Combined with tooltips and the occasional journey to the properties dialog it solves the problems I work on. The only downside is that the plan view tends to be verbose and the zoom options just don't work well...
    Posted to It Depends (Weblog) by Andy Warren on 08-12-2008

  • Rebuilding Stats: Twice or Not at All Posted on SSC

    Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the article was that if you're rebuilding indexes with the default options you're automatically getting stats update on those columns as well.
    Posted to It Depends (Weblog) by Andy Warren on 07-29-2008

  • Performance Tuning Seminar in Jacksonville, FL on May 2, 2008

    I'll be teaching a one day performance tuning seminar that targets beginning DBA's and developers that do data access, hoping to provide some useful insight into things that they can do immediately to address performance problems. It's on May 2, 2008 in Jacksonville and will serve as the...
    Posted to It Depends (Weblog) by Andy Warren on 03-09-2008

  • Computed Columns Published on SSC

    I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level performance tuning class . It's not a technique you'll apply that often, but I think it's used less often than perhaps it should be. Hope you'll take a look and add a comment...
    Posted to It Depends (Weblog) by Andy Warren on 02-12-2008

  • Partitioning Part 3 Posted on SSC

    Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in some basic performance tuning information as well, looking at the query plan when partitioning is done correctly vs incorrectly. The final installment has been submitted and will cover the SQL 2005...
    Posted to It Depends (Weblog) by Andy Warren on 01-08-2008
Page 1 of 1 (5 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems