Collations and Performance

2022

TL; DR

When collation affects performance a lot - and when hardtly at all

Session Details

You might have asked yourself: What effect does my choice of collation have performance? In this session I will cover two situations where the collation has a dramatic impact on performance. I will also discuss the impact in more general cases, based on data from performance tests I have run.

3 things you'll get out of this session

Speaker

Erland Sommarskog's previous sessions

Analysing and Resolving Deadlocks. - 2024

Ask the Expert - Group A (Thu 14:10 to 15:00) - 2024

Don’t Let Your Permissions Be Hijacked! - 2023

Collations and Performance - 2022

Don't Bite Off More than You Can Chew - Take it in Chunks - 2022

How sp_sqltrace Can Help with Your Performance Troubleshooting - 2022

Looping Abreast - 2022

Some Things You May Want to Know About Collations - 2022

SQL Titbits for the Inexperienced - 2022

Packaging Permissions in Stored Procedures - 2019

Dynamic Search Conditions - 2016