SQL Server optimization project

Completed 4 hour optimization project for small business SQL server. The steps included index optimization on few 200K+ heaps as well as rewrite of linear stored procedure using group by/having tricks. SQL 2005 would allow it even better with PIVOT, but SQL 2000 made it pretty good too.