Administration

Using Recommendations for MAXDOP and Max Memory During Installation

  • Article

Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]

3.67 (3)

2020-09-01

3,176 reads

Blogs

Why I am running for the PASS Board in 2020

By

This blog post lists the reasons why I felt the need to run for...

Blog Refresh – Growing Readers

By

Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...

Daily Coping 27 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Trying to get a arithmetic operation from an Variable

By itmasterw 60042

Hi, I am not sure if this can be done, but I seem to...

'xp_sqlagent_notify' error on job run

By Brandie Tarvin

Recently, our corporate office forced us to downgrade some non-prod servers from enterprise edition...

SSIS projects connection manager driver

By sqlfriend

Hi I am starting using the project deployment mode. I am using SQL server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers