In SQL Server, the affinity mask option can be configured without requiring a restart of the instance of SQL Server. When you're using sp_configure, you must run either RECONFIGURE or RECONFIGURE WITH ...