The dangers of over indexing your SQL Server tables
I have been teaching SQL Server recently in my capacity as MCT and to be totally honest with you I enjoy it very much.The topic that kept popping up all the time was indexes and how to use indexes to achieve high performance in SQL Server .Indexes is a vast subject and well documented elsewhere on the web.In most cases the answer is “it depends” when someone asks me if a column in a particular table needs to be indexed. It is a very challenging and iterative process.(
read more)