SSMS Issues with Intellisense and switching query windows

  • Does anyone else experience constant problems with switching between multiple query windows and having text from one query run over the other?

    Basically, if I have several query windows open within a single instance of SSMS, when I click on a different query tab, sometimes the contents of the previous tab appear to overwrite the other screen.  It's only a display issue, which I can select other query windows and come back to the one that I want and, eventually, after playing around a while, the correct text of the correct query window is finally displayed.

    Sometimes, I also notice that I get some strange conglomeration of two separate queries that seem to be overlaid on the same query tab.. I can edit, but I'm only actually editing the original query, not the garbage being shown on screen. 

    Also, I notice that Intellisense is sometimes slow and often does not work at all.

    I'm running on a i7-6700 with 16 GB of RAM, so I hardly think this is because my PC is too slow.  I should also mention I'm running Windows 10 64-bit SSMS 2016 (13.0.16106.4)

    Any suggestions, or should I just resign myself to the fact that Microsoft's primary tool for working on SQL Server is always going to be buggy and prone to issues?

  • bartedgerton - Monday, March 13, 2017 3:59 PM

    Does anyone else experience constant problems with switching between multiple query windows and having text from one query run over the other?

    Basically, if I have several query windows open within a single instance of SSMS, when I click on a different query tab, sometimes the contents of the previous tab appear to overwrite the other screen.  It's only a display issue, which I can select other query windows and come back to the one that I want and, eventually, after playing around a while, the correct text of the correct query window is finally displayed.

    Sometimes, I also notice that I get some strange conglomeration of two separate queries that seem to be overlaid on the same query tab.. I can edit, but I'm only actually editing the original query, not the garbage being shown on screen. 

    Also, I notice that Intellisense is sometimes slow and often does not work at all.

    I'm running on a i7-6700 with 16 GB of RAM, so I hardly think this is because my PC is too slow.  I should also mention I'm running Windows 10 64-bit SSMS 2016 (13.0.16106.4)

    Any suggestions, or should I just resign myself to the fact that Microsoft's primary tool for working on SQL Server is always going to be buggy and prone to issues?

    I have a very similar hardware/software config and do not see this behaviour, so I would suspect something else. I have Intellisense mostly disabled, however, because I use SQL Prompt (I leave Underline Errors turned on).

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I'm wondering if this has something to do with IE?  The "About" information from SSMS says 9.11, but I have 11.54 installed.  I suppose SSMS IE is different than the regular IE application?

    Microsoft SQL Server Management Studio      13.0.16106.4
    Microsoft Analysis Services Client Tools      13.0.1700.441
    Microsoft Data Access Components (MDAC)      10.0.10586.0
    Microsoft MSXML      3.0 6.0
    Microsoft Internet Explorer      9.11.10586.0
    Microsoft .NET Framework      4.0.30319.42000
    Operating System      6.3.10586

  • I've seen the behavior and it's mostly a display refresh issue. I usually fix it by scrolling the query.
    Remember that even if you have a good computer, SSMS is still a 32-bit application (at least until SSMS 2014).

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Here's mine:

    I've never even stopped to think about why they quote IE version in this list. I have 11.576 installed.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • I don't know either.  It's extremely frustrating that the primary software I use to do my job has so many problems with the interface itself. 

    I'm changing the location of my settings file to a local drive, and I'm turning off "Detect when file is changed outside environment" and "check for consistent line endings on load".

    I'm hoping this will improve performance.  Right now, clicking on different objects in object explorer causes SSMS to hourglass for 30 seconds or more occasionally.  I have the same problem switching from one query window to the next.   I can have this same issue even when the only other app running on my computer is Outlook.  I also have ensured that all local SQL Server services are not running.  My machine's memory and cpu are never being taxed when SSMS is spinning.

    I'll update if these settings changes help.   The next thing I'm going to do is disable the nearly useless Intellisense, if this doesn't' help.

Viewing 6 posts - 1 through 5 (of 5 total)

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