Changing SQL Server Configurations : sp_configure « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_configure

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)')