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
Last activity: Aug 4, 2022, 08:41 PM