Browse by Tags

All Tags » Performance Tuning (RSS)
13 August 2008 01:53

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...
Posted by Andy Warren | with no comments
Filed under: ,
30 July 2008 01:31

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...
Posted by Andy Warren | with no comments
Filed under: , ,
10 March 2008 01:52

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...
Posted by Andy Warren | with no comments
Filed under: , ,
12 February 2008 07:57

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...
Posted by Andy Warren | with no comments
Filed under: , ,
08 January 2008 09:56

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...
Posted by Andy Warren | with no comments
Filed under: ,