Page Comparison

Option

Setting

SQL Server Edition

Standard or Enterprise

Version

See System Requirements and Compatibility.

Collation Character set

Latin1_General_CI_AS

Max Server Memory

Do not set a fixed maximum memory; see MS SQL Server planningPlanning

Server Authentication

SQL Server and Windows Authentication Mode