SQL Server (DP)

What is the Maximum amount of Memory I should configure SQL to use for a SCCM Site Database Server? To avoid potential performance problems, you have to configure SQL to use the correct maximum amount of memory depending on where … Continued

What is the Minimum amount of Memory I should configure SQL to use for a SCCM Site Database Server? To avoid potential performance problems, you have to configure SQL to use the correct minimum amount of memory for the type … Continued

What are the different Versions Numbers for Microsoft SQL Server? Over the years Microsoft has released various versions of SQL Server, each with its own version number which are detailed in this FAQ.

Why should I configure Maximum and Minimum Memory settings for SQL? There are very good reasons not to accept the default values for the Minimum and Maximum memory settings for SQL (any version), especially with SCCM.

Which type of account should I use for my SQL Server Reporting Services (SSRS) installation? Like with most things in life you have a choice when it comes to deciding which type of account the SQL Server Reporting Services service … Continued