A table tAudit contains Millions of Millions of records. Now I would like to change a dataype of of a column int to bit. Which one is faster whether Alter column option or
Rename the column
Create a new column with bit datatype with existing name.
Update the new column with old column value
Drop the old column.