I have sql server table with 70M rows.
I need to increase the field len of a single field.
Last time I did this it toke 5 hours.
What is the fastest way to run something like this. I don't care about log files or having to revert. I don't have 5 hours to wait.
ALTER TABLE myTable
ALTER COLUMN [Customer] nvarchar(150)