Post reply

Managment Studio. Different PC's give different result for same query.

  • November 10, 2011 at 3:52 am

    #1405612

    Scott Levy (11/9/2011)

    Just a last update on this if anyone is interested as I think I may have found the source of the inconsistency.

    I believe that it was the local intellisense cache of the DB schema that management studio holds. I have been having issues with it flagging tables and fields as invalid when they are definitely there, a force refresh of the local cache and the issue goes away.

    Scott

    problem of cache that occurs with intellisense, not affect the results of server!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • November 10, 2011 at 3:53 am

    #1405613

    codebyo (11/10/2011)

    Dev @ +91 973 913 6683 (11/9/2011)

    I am not convinced. Intellisense helps developers to write SQL code in SSMS with ease. It’s IDE feature. It should not affect your query results.

    I was able to reproduce the behaviour where intellisense would be outdated and sometimes would show syntax errors while editing the code.

    But it would execute the commands with no erros as that issue doesn't affect the SQL parser. I can't see how a intellisense bug could influentiate the parser's behaviour.

    Best regards,

    I agree with you!!!!:-D

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • November 10, 2011 at 3:54 am

    #1405614

    Dev @ +91 973 913 6683 (11/9/2011)

    Scott Levy (11/9/2011)

    Just a last update on this if anyone is interested as I think I may have found the source of the inconsistency.

    I believe that it was the local intellisense cache of the DB schema that management studio holds. I have been having issues with it flagging tables and fields as invalid when they are definitely there, a force refresh of the local cache and the issue goes away.

    Scott

    I am not convinced. Intellisense helps developers to write SQL code in SSMS with ease. It’s IDE feature. It should not affect your query results.

    I agree with you!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • November 10, 2011 at 5:07 am

    #1405638

    Scott Levy (11/9/2011)

    Just a last update on this if anyone is interested as I think I may have found the source of the inconsistency.

    I believe that it was the local intellisense cache of the DB schema that management studio holds. I have been having issues with it flagging tables and fields as invalid when they are definitely there, a force refresh of the local cache and the issue goes away.

    Scott

    Interesting notion and even more interesting solution... I've seen stranger things happen but not by much. We had similar problems with Intellisense redflagging tables and columns. It hasn't affected any runs (yet) but I can see it coming someday. How did you refresh the local cache, Scott?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • November 10, 2011 at 2:41 pm

    #1406028

    How did you refresh the local cache, Scott?

    Edit | Intellisense | Refresh Local Cache (Shift+Control+R)

    It only appears when you have a query open for editing I think.

    Scott

  • November 10, 2011 at 3:22 pm

    #1406038

    Scott Levy (11/10/2011)

    How did you refresh the local cache, Scott?

    Edit | Intellisense | Refresh Local Cache (Shift+Control+R)

    It only appears when you have a query open for editing I think.

    Scott

    Just to be clear... You did not receive any errors upon execution. You were just stumped as to why it was underlined in red as a non-existent column?

    Jared

    Jared
    CE - Microsoft

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply