Alter Index Add Column - Workaround - SQL in Sixty Seconds 097
It is not possible to Alter Index and Add Column. You have to drop and recreate the index. In this quick video, we will see a workaround to this problem.
Here is the associated blog post: https://blog.sqlauthority.com/2020/08...
0:00 Introduction
0:38 Script for Alter Index
1:02 Script for Adding Column
1:29 Summary
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
#SQLServer #PerformanceTuning #SQLAuthority