SQL Server 2012 intellisense

Question

Why sometimes i have to wait for the intellisense reaction, which never comes and sometimes the intellisense works fine and fast?

Bad connection to the server or some configuration problem?

Answer 1

It caches intellisense information (which is why you sometimes need to refresh manually). When this needs to be refreshed/retrieved, it takes a short time; afterwards it just uses cached information which is available right away.

So if you have the impression that the intellisense doesn't work (e.g. no popup, or missing or outdated information), just refresh it: CTRL+SHIFT+R (Edit -> Intellisense -> Refresh Local Cache).

It's also important to remember that only 2008 onwards supports Intellisense; if you connect to a pre-2008 database with the new SSMS you still won't get Intellisense.