SELECT name, value_in_use
FROM sys.configurations
WHERE name IN ('max degree of parallelism')
EXEC sp_configure 'max degree of parallelism', 1
RECONFIGURE
GO
EXEC sp_configure 'max server memory', 250
RECONFIGURE
GO
SELECT name, value_in_use
FROM sys.configurations
WHERE name IN ('max degree of parallelism', 'max server memory (MB)')