Video unavailable

SQLBits 2022

Collations and Performance

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

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.

Speaker

Erland Sommarskog is an independent consultant from Stockholm. He has been working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has held the award since.

Erland Sommarskog's Sessions

Analysing and Resolving Deadlocks.

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

Don’t Let Your Permissions Be Hijacked!

Collations and Performance

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

How sp_sqltrace Can Help with Your Performance Troubleshooting

Looping Abreast

Some Things You May Want to Know About Collations

SQL Titbits for the Inexperienced

Packaging Permissions in Stored Procedures

Dynamic Search Conditions