I need to change a column from NOT NULL to NULL in a table that contains millions of rows. I've tried a simple
alter table Table1 ALTER COLUMN Column1 XML NULL
but it takes forever. So here are my questions:
- Why does it take so long to apply the alter?
- Is there a better way to do it?