SQL Server Indexing

Here is a good post covering the basics of SQL Server indexing and here is another on determining if your existing indexes are being used effectively.