I was working through some performance issues on a "fun" table. A bit of half a billion rows and with some apparent I/O issues as the entire table is being read by some of the clients services to create an extract. In working through some of the performance bottlenecks, I found the following white paper quite helpful... of course, the name of the white paper indicates how helpful it was...
Troubleshooting Performance Problems in SQL Server 2005.