I am writing this a follow up to Changing data type of column in SQL Server

My question earlier was if I need to remove all indexes and constraints and it was answered I do need to remove them.

So as I was surf internet on the topic I came across a few post saying its better to disable and enable an index, rather than removing and recreating them .

So which is better way of doing it? Does disabling of index allow you to change the data type of the column as well? What is the difference between both?

Statement with dropping and creating index

DROP INDEX UX_1_COMPUTATION ON  dbo.Computation 

ALTER TABLE dbo.Computation
ALTER COLUMN ComputationID NVARCHAR(25) not null

CREATE UNIQUE INDEX UX_1_COMPUTATION ON dbo.Computation (ComputationID);

Statement with disabling and enabling index

ALTER INDEX [UX_1_COMPUTATION ] ON  dbo.Computation DISABLE

ALTER TABLE dbo.Computation
ALTER COLUMN ComputationID NVARCHAR(25) not null

ALTER INDEX [UX_1_COMPUTATION ] ON dbo.Computation REBUILD;
Edit
Report