• QO = query optimizer.

    As for how to circumvent those implicit conversions - nothing comes to mind at the moment (without the code rewrite).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events