Random SQL Links - SQL Server 2000 vs 2005 indexing commands

http://searchsqlserver.techtarget.com/news/1166244/SQL-Server-2000-indexing-dos-and-donts

http://searchsqlserver.techtarget.com/tutorial/Tutorial-SQL-Server-indexing-tips-to-improve-performance

http://www.sqlteam.com/article/indexed-views-in-sql-server-2000

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.mssqltips.com/tipprint.asp?tip=1044

http://www.mssqltips.com/tip.asp?tip=1014

http://www.mssqltips.com/tip.asp?tip=1015

http://www.mssqltips.com/tip.asp?tip=1018

http://www.mssqltips.com/tip.asp?tip=1209