SQL Server localization

Question

Does SQL Server take over the localization from the server it's installed on? Or can you define the locale for each instance/database?

Which setting is responsible for having comma or period when a double is saved to the database?

Answer 1

SQL Server has a server collation and each database can either use the server collation or can be set to a different collation.

The format of the datatype will be taken from the Database collation. Providing that a collation has not been explicitly set for the column.

SQL Server Collations

Answer 2

Remember that if you use different collation for columns that you are trying to compare, you will need to use COLLATE and that will cause the argument to be a "non searchable argument", that is indexes will not be used to satisfy that statement.