This document outlines how to improve the end-user experience by optimizing the cube design for Microsoft Office Excel 2007 PivotTable dynamic views. Download here .
Also getting confused on which SQL2005 version you are running ? Which hotfix for which bug ? Maybe this can be a solution: Steve Jones has made a build list which is based on Aaron Bertrand's list
posted by
on
to
()
"Introduced in SQL Server 2005 Enterprise Edition, the online index feature provides a powerful way to perform maintenance operations such as rebuilding or creating indexes in a production system without sacrificing DML concurrency. This paper provides a detailed discussion of the index process and provides guidelines and best practices...
SQLQueryStress is a free tool for SQL Server programmers. It is designed to assist with performance stress testing of T-SQL queries and routines. The tool automatically collects metrics to help you determine whether your queries will perform under load, and what kind of resource strain they put on your server. http://www.datamanipulation...
Search the SQL Server Books Online via Windows Live Search. http://search.live.com/macros/sql_server_user_education/booksonline