Indexes, Basically - from SQL Bits
I'll put the entire content including as much as I can remember of what I said, the demo code and results onto my web site over the following week or so.
If you'd like the demo databases ( sql 2008 ) there are three, the largest being 60Gb - none really work on a laptop unless you like long waits between queries,
dop me a mail with your address and I'll send a set of native backups with the demo scripts.
( nothing tonight as I'm off to see Metallica at the O2 )
The following cover a few points I raised.
covering clustered indexes
http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/05/26/covering-clustered-indexes.aspx
size does matter
http://www.grumpyolddba.co.uk/sql2005/working%20with%20indexes%204.mht
( The excel spreedsheet which goes with size does matter)
http://www.grumpyolddba.co.uk/sql2005/working%20with%20indexes%204.mht