Sample Header Ad - 728x90

can use maxdop on online modifying column in mssql 2019?

0 votes
1 answer
413 views
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)
Asked by hadi pourneshati (17 rep)
Aug 2, 2022, 03:18 AM
Last activity: Aug 4, 2022, 08:41 PM