pdemro + collation   2

SharePoint SQL Collation - Best practice
Default Collation of the SharePoint Instance:
This configuration you have to Change if you install the instance on the SQL box. If you know, you will have only SharePoint in the Instance, you can configure this with Latin1_General_CI_AS_KS_WS. The result of them is that all System databases (Master, tempDB ...) has also the SharePoint collation and we do not loose Performance in SQL internally. Unfortunatelly you cannot Change the Default collation later on.
collation  microsoft  sharepoint  prerequisites  sql  install 
november 2017 by pdemro

Copy this bookmark: