#temptable

Introduction Have you ever wondered if the collation of your user databases and system databases in SQL Server could impact performance? As a database administrator, I’ve grappled with this question myself. In this article, I’ll share what I’ve learned about collations, how they affect queries, and whether it’s a good idea to change system database collations to match user databases. By the end,…