Grant Fritchey (1/6/2009)
Keep your indexes as small as you can.
But no smaller than necessary. If the index needs to be four columns wide to be useful, making it only 3 columns wide will probably mean it won't be used.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability