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

  • 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)