I know a lot of you already read Chris's Project Programmability blog - but in case you haven't seen this posting from last week it has a great tip for using the SQL Server 2005 capability of guiding a query to be executed in a specific way without touching the query itself. This uses sp_create_plan_guide. See http://blogs.msdn.com/project_programmability/archive/2007/09/07/improve-the-performance-of-building-the-project-server-data-analysis-cube.aspx for full details. For this particular customer scenario this made the difference between the query taking 17 hours and just minutes!
Technorati Tags: Project Server 2007