Collation Is Weird
In this video, I delve into the mysterious and often misunderstood world of collation in SQL Server, focusing on a peculiar issue that arose during a customer support session. Using a creative example involving a string of 50,000 characters, I demonstrate how different collations can lead to unexpected performance issues, particularly when it comes to updating statistics. The video explores the nuances between using a case-sensitive, accent-sensitive collation and the default SQL collation, highlighting the potential for misleading execution plans and extended wait times during statistic updates. Through this exploration, I aim to shed light on the complexities of collation management and offer insights into avoiding performance pitfalls in your own databases.
CHAPTERS
00:00:00 - Introduction
00:02:16 - Collation Overview
00:04:32 - Different Collations Explained
00:06:18 - Query Execution Plan Analysis
00:07:21 - Interesting Findings
00:09:22 - Statistics Creation Mystery
00:10:49 - Conclusion
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━