From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Installation options continued

Installation options continued - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Installation options continued

“

- [Instructor] Another option that you'll want to consider and plan out before you start the installation of your SQL Server is the collation settings. Collation determines how SQL Server will handle the sorting and the languages that it will support for that particular instance. Each instance of SQL Server can have its own collation settings, so what that means is that if you have multiple instances of SQL Server on a single computer, each can be configured to have its own collation settings. When you start the setup routine, SQL Server will detect your computer's locale based on what the Windows operating system has configured, and then it will select a default collation setting specific to what it finds in that locale setting. That doesn't mean that you have to keep that. You have the option to change that for each instance that you are installing. Again, the primary thing to keep in mind about collation settings, is it will determine how a lot of your results get returned, in…

Contents