Indexing?

Anyone got a great reference that explains what fields to index.. etc..

Would you index your foreign keys, or since the key of the referenced table is indexed should I not?

In almost all cases, Foriegn Keys should be indexed.

Indexing strategies

Dear all,
I'd like to explore more about indexing strategies and would appreciate
a reference to some good resources this regard including book names.

Best regardsThis is your best choice (In my opinion)

Inside Microsoft SQL Server 2000
by Kalen Delaney
http://www.amazon.com/exec/obidos/t...=glance&s=books

Denis the SQL Menace
http://sqlservercode.blogspot.com/