This is not an article or a script. I am posting this just to share my experience and I feel it can save a lot of time in a specific situation.
– We have a table let’s say Customer and this table has an alpha numeric primary
key CustomerID varchar(10). Due to unexpected growth in volume of data we
figure out varchar(10) was not sufficient and we decided to make it varchar(50).