The Red9 Blog

Get our new tips before anyone else. Enter your email below to join our private list!

Most Popular Red9 Posts

Latest From Red9

What is the MAXDOP setting in SQL Server?

Category: Performance Item: Default Max degree of parallelism The max degree of parallelism option is used by SQL Server to limit the number of processors

SQL Server startup parameters

Category: Reliability Item: SQL Engine startup settings What are SQL Server startup parameters? When you install SQL Server, setup writes a set of default startup

Trace flags in SQL Server

Category: Performance Item:  Trace flags What is a Trace Flag in the SQL server? SQL Server trace flags are configuration handles that can enable or

SIMPLE recovery model in SQL Server

Category: Reliability Item:  SIMPLE recovery model usage What is the SIMPLE recovery model in SQL Server? Simple Recovery Model is the basic recovery model available

SQL Server page verification CHECKSUM

Category: Reliability Item:  Page Verification not optimal What is Page verify in SQL Server? Page Verify is a database option that defines the mechanism used by SQL

Optimal power plan for SQL Server

Category: Performance Item:  Windows Power plan CPU performance and Windows power plans Usually, the balanced power plan is set by default, which is what Microsoft

Fail-safe operator for SQL Server agent

Category: Reliability Item:  No failsafe operator What is a fail-safe operator in SQL Server? A fail-safe operator is a backup user who receives the alert

Best practices for the SQL Server shrink

Category: Reliability Item: DBCC Shrink ran recently What is shrinking a database in SQL? Shrinking data files recovers space by moving pages of data and

SQL Server max memory parameter

Category: Performance Item:  Default max memory setting. Why should you care about max memory in SQL Server? SQL RAM max memory default setting is terrible.