Width sensitive and insensitive collation examples in sql server

In collation name meaning WS

WS: Width sensitive

Example of width insensitive comparison in sql server

IF 'm3' = 'm³' COLLATE Latin1_General_CI_AI

    SELECT 'Width insensitive'

ELSE

    SELECT 'Width sensitive'  

Output:  Width insensitive

Example of width insensitive comparison in sql server

   

IF 'm3' = 'm³' COLLATE Latin1_General_CI_AI_WS

    SELECT 'Width insensitive'

ELSE

    SELECT 'Width sensitive'

Output:  Width sensitive

Indexes best practices in sql server: Where to start creating indexes?
Sql server query optimization tips : Tuning best practices with examples
Fastest or most efficient way to insert data in sql server
Index in sql server with examples
What is clustered index in sql server