Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I want to change data type of a column of my table in SQL Server 2019. My table has 50,000,000 row and it's very important. I want to do this operation online and also handle maxdop to avoid CPU over usage. I wrote this query but I got syntax error:
Alter table Customers
alter column FirstName char(16) not null
with (online = on, maxdop = 4)
Per the Microsoft Docs, SQL Server 2019 ALTER TABLE ... ALTER COLUMN syntax does not support the MAXDOP = x option.
MAXDOP = x is only supported for single partition rebuilds and constraint operations.
