Alter Index Add Column – Workaround – SQL in Sixty Seconds #097


 

During the recent Comprehensive Database Performance Health Check, I identified at my client’s place that we needed to modify one of the indexes and add a couple of additional columns to improve its performance. However, while modifying it we faced a unique challenge that we can’t actually alter index to add columns. Let us discuss that today.

Alter Indexes to Add Column – Not Possible

While SQL Server indeed supports the ALTER INDEX syntax, it allows it for the making changes to various storage properties like fill factor, compression etc. However, it does not allow you to add or remove columns from