Dom Cosgrove Blog

This is for my own quick reference, as it is in the Microsoft Installation Documentation. I also find that SQL Server is often installed by a separate team and the default collations are selected. The correct SQL Collation should be:

Latin1_General_CI_AS_KS_WS

• Latin1_General Character Set ;
• Case Insensitive – A and a are treated as the same character;
• Accent Sensitive – a and á are NOT treated as the same character;
• Kana Sensitive – Japanese Hirakana and Katakana characters which look the same are NOT treated as the same character;
• Width Sensitive – Single-Byte and Double-Byte versions of the same character are NOT treated as the same character;

Best Practices for SharePoint Content Databases in SQL Server

http://www.mssqltips.com/tip.asp?tip=1777

Deploy using DBA-created databases (Office SharePoint Server)

http://technet.microsoft.com/en-us/library/cc262869.aspx

Whitepaper: Database Maintenance for Microsoft SharePoint Products and Technologies

http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0×409