MAXDOP
sp_configure 'show advanced options', 1;
go
reconfigure;
go
sp_configure 'max degree of parallelism', 4;
go
reconfigure;
go
sp_configure 'show advanced options', 1;
go
reconfigure;
go
sp_configure 'max degree of parallelism', 4;
go
reconfigure;
go