I’m very impressed with an article that I found on SQL Server Pro.

http://www.sql-server-pro.com/sql-server-configuration.html

The article discussed how to installing and configuring Microsoft SQL Server  after completed  the software installation.

In addition, the article discussed and explained detail on each SQL Server Configuration components.

• Affinity Mask
• Affinity IO Mask
• Cost Threshold for Parallelism
• Fill Factor
• Index Create Memory
• Locks
• Max Degree Of Parallelism
• Max Worker Threads
• Min and Max Server Memory
• Min Memory Per Query
• Piority Boost
• Recover Invertal
• Disk Configuration
• Startup Options

To view SQL Server Configuration:

Method 1:

EXEC SP_CONFIGURE ‘Show Advanced Options’, 1

GO

RECONFIGURE

GO

EXEC SP_CONFIGURE

GO

Method 2:

SELECT * FROM  SYS.CONFIGURATIONS

GO