Page Comparison

Option

Setting

SQL Server Edition

Standard or Enterprise

Version

See System Requirements and Compatibility.

Collation Character set

Latin1_General_100_CI_AI_ASSC_UTF8

The database that PhixFlow runs against must be created with the collation set to this character set (see Install the PhixFlow Database Schema), otherwise the performance of PhixFlow can be severely impacted. However, PhixFlow uses TEMP tables for efficient processing of ‘is in’ filter clauses with large numbers of parameters, and this uses the collation setting of the server itself. Therefore, it is strongly recommended that the server is set to use this collation.

Parameter

Setting

Collation

Latin1_General_100_CI_AI_SC_ASUTF8

READ_COMMITTED_SNAPSHOT

ON

Option

Setting

SQL Server Edition

Standard or Enterprise

Version

See System Requirements and Compatibility.

Collation Character set

Latin1_General_100_CI_ASAI_SC_UTF8

Max Server Memory

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

Server Authentication

SQL Server and Windows Authentication Mode