Learn how a binary collation changes SQL Server sorting, exact string comparisons, index access, and column metadata checks.
Collation Precedence: Which Collation Wins in a Comparison
Explain collation precedence with explicit and implicit labels, reproduce a conflicting join, and choose comparison rules.
SQL SERVER – How to Convert CollationID to Collation Name?
A reader with only MDF files and no backups got a CollationID from DBCC CHECKPRIMARYFILE. Here is how to convert that CollationID to a Collation Name.
SQL SERVER – Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors
SQL SERVER – Could Not Use View or Function ‘msdb.dbo.sysdac_instances’ Because of Binding Errors. Let us learn how to fix the error.
SQL SERVER – Case of Different Default Collation on Two Servers
My client saw a different default collation on two servers installed with SQL Server 2012. Here is what decides the default collation during setup.
SQL SERVER – How to Change SQL Server Collation on Microsoft Azure VM (IaaS)
Azure gallery VMs install SQL Server with SQL_Latin1_General_CP1_CI_AS. Here is how to change SQL Server Collation on such a VM by rebuilding system databases.
Interview Question of the Week #031 – How to do Case Sensitive SQL Query Search
Run a case sensitive SQL query search with explicit collations, inspect current settings, and design an index for repeated exact matches.