General SQL Server Design & Planning FAQs

This page contains the various categories for the General Microsoft SQL Server Design & Planning FAQs.

General

• What are the different Versions Numbers for Microsoft SQL Server?

SQL Configuration

• Memory
  • Why should I configure Maximum and Minimum Memory settings for SQL?
  • What is the Minimum amount of Memory I should configure SQL to use for a SCCM Site Database Server?
  • What is the Maximum amount of Memory I should configure SQL to use for a SCCM Site Database Server?

SQL Server Reporting Services (SSRS)

• Which type of account should I use for my SQL Server Reporting Services (SSRS) installation?