Indexes in SQL Server

Here's a great article on the ins and outs and do's and dont's of indexing in SQL Server, its a beginner level article but explains pretty much there is to know about indexing.

http://www.odetocode.com/Articles/70.aspx

The above mentioned article focuses on SQL Server 2000, for a comparison with SQL Sever 2005 indexes, click here , on the whole it adds a new type of index for xml datatype that it supports and enhances on previous things, nothing dramatically new.