Find unused columns

  • SQLHeap

    Hall of Fame

    Points: 3502

    Comments posted to this topic are about the item Find unused columns

    There is an exception to every rule, except this one...

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    I tried it on one table. After 20 minutes it hadn't finished so I cancelled the operations.

  • Eric M Russell

    SSC Guru

    Points: 124992

    Even if a column contains the same value for every row, it can still very well be used. If you do choose to remove the physical column, you may want to replace it with a non-persisted computed column.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply