I grew to like case insensitive dbms like SQLServer as it makes me think less about casing when I write queries, but always wondered if that comes at cost of performance!
Collation in a database determines case sensitivity in MSSQL. If the collation has "cs", it's case-sensitive. If it has "ci", it is case-insensitive.
Collation is configurable at the server level, but usually one goes for a _CI_ collation there (not much reason for master to be _CS_). Each user database can have it's own collation/case-sensitivity.
p_ing|10 months ago
Collation is configurable at the server level, but usually one goes for a _CI_ collation there (not much reason for master to be _CS_). Each user database can have it's own collation/case-sensitivity.