I inherited a database that has a non-clustered index on a column and also has a clustered index on the same column. This table gets hit with a lot of inserts. I have noticed tons of locking lately. The locking is so severe that all reads and writes stop working. Due to the heavy inserting, I'm assuming the clustered index should be dropped. Any opinions on this? Thanks.