Home Forums Article Discussions Article Discussions by Author Discuss content posted by Edward Pollack Finding and Eliminating Duplicate or Overlapping Indexes RE: Finding and Eliminating Duplicate or Overlapping Indexes
Carlo Romagnano
SSC-Insane
Points: 22611
More actions
June 16, 2014 at 2:58 am
#1721861
Replace:
STUFF((SELECT ', ' + COLUMN_DATA_KEY_COLS.name
with:
STUFF((SELECT ', ' + COLUMN_DATA_KEY_COLS.name + ' ' +SUBSTRING('+-',INDEX_COLUMN_DATA_KEY_COLS.is_descending_key+1,1)