I recently moved to the Central Performance Team in the SQL Server product group. My group is responsible for box-wide performance, benchmark and scalability. Given my new role I will be posting more of performance tips and techniques. I will be covering the following topics:
- Query performance tips
- Engine features that improve performance
- Troubleshooting performance problems using new SQL Server 2005 features
- Differences between SQL Server 2000 and SQL Server 2005 with respect to certain features or behavior changes that might affect performance
Please comment to this post if you would like some specific topics to be covered.