Every time I use Sequel.like, it generates a LIKE with a COLLATE:
(([XDR_TO] COLLATE Latin1_General_CS_AS) LIKE ('%blah%' COLLATE Latin1_General_CS_AS) ESCAPE '\')
that COLLATE makes the SQL run like 3x slower than without the collate.... and I dont need the collate.
MSSQL server tells me the column is collated as:
How to fix?