I might be asking a rather stupid questuion… but here goes…
Is there any noticable performance-cost on the server-side, if the collation-setting for the Database is other than the collation-setting on the server?
([^o)] Could this be an “enter enter enter”-installation of SQL-server on english OS, and a “Cronus Denmark”-demoDB… [:D])
Today I have read a lot of articles covering collation, how great it is that we can define an alternative collation on a database if needed, instead of having to change collation on the whole server etc. etc…
But not one (of the articles I found) covered what performance-cost it causes (if any).
In my logic there has to be some performance-cost from this.