Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Odd behavior -- execution plan different when I execute in the target database vs not in the target database RE: Odd behavior -- execution plan different when I execute in the target database vs not in the target database

  • TheSQLGuru - Tuesday, May 8, 2018 11:04 AM

    Jason A. Long - Monday, May 7, 2018 9:23 PM

    TheSQLGuru - Monday, May 7, 2018 6:05 PM

    Maybe DB2 has the same objects and something different (like 10000X more data, missing indexes, different data types, etc)?

    The best way to help you is to post the query plans.

    Good to see you back Kevin! Hope all is well.

    Thanks for asking Jason, but sadly no. 🙁 But I miss helping the SQL Community out so I have decided to pick one to respond to now and again.

    I'm not one to pry, so I won't... but if there's anything I can do, shoot me a PM.
    In any case, whatever it is, I'm rooting for you. 🙂