When you use remote database with low transfer connection (for example I connected from Europe to far Asia's office server) and when the database's structure is not small (for example many tables) then it takes much more time for SSMS to complete all Intelli Sense data.
In my case I had to wait over 1 minute to have Intelli Sense accessible (slow connection and db with about 1000 tables).
Microsoft Intelli Sense provides an array of options that make language references easily accessible.
When coding, you do not need to leave the editor to perform searches on language elements.
As a Developer or as a DBA you may face issues with Intelli Sence feature not to be working or not displaying latest scheme changes when you are writing TSQL code within the Query Window of SQL Server Management Studio (SSMS).
The editors in SQL Server Management Studio support Microsoft Intelli Sense options that reduce typing, provide quick access to syntax information, or make it easier to view the delimiters of complex expressions.You can keep your context, find the information you need, insert language elements directly into your code, and even have Intelli Sense complete your typing for you.In SQL Server 2008, Microsoft had introduced Intelli Sence feature in SQL Server Management Studio (SSMS).SQL Prompt now offers code suggestions for Azure SQL Data Warehouse, when you’re developing in either SSMS or Visual Studio.If you’re just getting started with Azure SQL Data Warehouse, or simply want to learn more, take a look at this helpful article from Robert Sheldon: Getting started with Azure SQL Data Warehouse Similarly, we’ve added suggestions for Analytics Platform System (APS, formerly known as Parallel Data Warehouse, or PDW).