Jeff M

My feedback

  1. 7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Dec 28 2017 10:38AM=-=>

    Defect #11427260 has been filed with our Product group on your behalf – Karly Shockley

    <=-=Dec 28 2017 11:34AM=-=>

    Shared here…

    Transact SQL � Warning � �Type conversion in expression may affect �CardinalityEstimate� in query plan choice�
    https://learningintheopen.org/2017/12/13/transactsqlwarningtypeconversion-in-expression-may-affect-cardinalityestimateinqueryplanchoice/

    Jeff M supported this idea  · 
    An error occurred while saving the comment
    Jeff M commented  · 

    +1 on Martin Freeman's comment. I ran into this as well and this false positive noise hinders the discovery of legitimate performance problems. Ref. https://stackoverflow.com/questions/55546183/concatenation-of-int-columns-warning-type-conversion-in-expression-causes-cardi/55578486#55578486

Feedback and Knowledge Base