but, there isn’t a nice clean way to show all of the included columns for all indexes for a particular table… until now :)A couple of weeks ago I sat down and rewrote sp_helpindex. I was actually on a plane from Hyderabad to Frankfurt...
CREATE INDEX ix_4 ON tbl1(c1, c3) INCLUDE (c2) CREATE INDEX ix_5 ON tbl1(c3) INCLUDE (c1, c2, c4) CREATE INDEX ix_6 ON tbl1(c1, c2) INCLUDE (c3, c4) go sp_helpindex2 tbl1 go index_name index_description index_keys included_columns ix_1 nonclustered located on fg1 c1...