• Thanks for helping me identify a query where by using OPTION(RECOMPILE) I was able to reduce execution time of "completely unpredictable" to a few seconds. 🙂

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com