Post reply

SSMS's intelliSense

  • May 19, 2015 at 3:31 pm

    #297104

    I had SSMS installed for about 2 months. IntelliSense has been working until 1 week ago and it somehow stopped. I have looked at all the options in the SSMS menu/submenu (for editor menu's, etc.) However, I am still unable to turn it back on.

    Did anyone run into this problem before or know how to turn IntelliSense back on for me?

    I appreciate your help!

    Thanks,

    Long N.

  • May 19, 2015 at 4:07 pm

    #1799192

    Check to make sure IntelliSense is activated...

  • May 20, 2015 at 3:34 pm

    #1799496

    Thank you, Jason, for your reply.

    Yes, Intellisense was 'Enabled' in SSMS, but somehow the editor still does not complete the codes... (very frustrating when you have to keep looking at the columns and typing every letters, and correcting the typos!)

    I thought about reinstalling SSMS... but don't know if it would cause any 'unpredictable problems, such as affecting the database and scripts...

  • May 20, 2015 at 3:38 pm

    #1799497

    Hi Jason,

    I could not paste the screenshot into my post so I had to include it as an attachment.

    How did you do it?

    Thanks,

    Long

  • May 20, 2015 at 4:16 pm

    #1799502

    Intellisense tends to work best when you give it a little help...

    Stare your query like this...

    SELECT

    *

    FROM dbo.MyTable mt

    Now you should be able to go back into the select list...

    SELECT

    mt.<intellisense>

    FROM dbo.MyTable mt

    If you still aren't getting any suggestions, check the are I showed in my 1st post and also check... Tools > Options > Text Editor > Transact-SQL > Intellisense and make sure the appropriate boxes are checked.

  • May 20, 2015 at 4:35 pm

    #1799506

    You can also refresh the cache IntelliSense uses using Ctrl+Shift+R. It might take a little bit to reload.

    Joie Andrew
    "Since 1982"

  • May 20, 2015 at 4:41 pm

    #1799507

    I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes away and comes back based on how my system is doing. When my memory and CPU is high it just does not work. It's just something I have always experienced and have never gotten to the bottom of.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • May 20, 2015 at 4:48 pm

    #1799509

    Alan.B (5/20/2015)

    I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes away and comes back based on how my system is doing. When my memory and CPU is high it just does not work. It's just something I have always experienced and have never gotten to the bottom of.

    Yea... This is where external tools like SQL Prompt are worth their weight in gold (assuming software weighed something). The SQL Prompt Code Suggestions are much better (IMO).

  • May 20, 2015 at 4:54 pm

    #1799511

    Jason A. Long (5/20/2015)

    Alan.B (5/20/2015)

    I have noticed that in SQL Server 2012 and 2014 (perhaps previous versions as well but I don't remember) Intellisence is just downright flaky. It goes away and comes back based on how my system is doing. When my memory and CPU is high it just does not work. It's just something I have always experienced and have never gotten to the bottom of.

    Yea... This is where external tools like SQL Prompt are worth their weight in gold (assuming software weighed something). The SQL Prompt Code Suggestions are much better (IMO).

    I agree 100%.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • May 20, 2015 at 5:22 pm

    #1799516

    Disclosure: I work for Red Gate.

    If you want to get Prompt and show it helps, I'd get some queries you normally write, and time the effort in Intellisense to reproduce them. Then time with Prompt, though you might need a half hour to get used to how Prompt works differently.

    I would bet you could extrapolate the hours you type across a year, and the amount of additional work you'd get done with Prompt.

  • May 20, 2015 at 8:11 pm

    #1799527

    Steve Jones - SSC Editor (5/20/2015)

    Disclosure: I work for Red Gate.

    If you want to get Prompt and show it helps, I'd get some queries you normally write, and time the effort in Intellisense to reproduce them. Then time with Prompt, though you might need a half hour to get used to how Prompt works differently.

    I would bet you could extrapolate the hours you type across a year, and the amount of additional work you'd get done with Prompt.

    I don't work for Red Gate. I'm just lucky enough to work for a company that's a customer of Red Gate. After having had SQL Prompt on all of my PCs for the last (almost) 3 years... There's no way I'll ever go without it again. Even if I had to come out of pocket for it myself. The Snippet Manager & the Format SQL tool & Code are each worth the price of admission individually. Combined, it's a no brainer...

    The sad part is that I probably don't even come close to using it's full potential. Well that and the fact that I may have lost the ability to actually write a stored proc from scratch...

  • May 21, 2015 at 9:46 am

    #1799742

    How big, in terms of number of objects, is your database? I've had some real problems with intellisense with a few of mine. They are pretty large by this measurement and intellisense only works intermittently for me.

    Tim

  • May 21, 2015 at 10:52 am

    #1799771

    Thank you, Jason and everyone for your kind replies!

    I tried to set/reset all settings within SSMS to make Intellisense work to no avail. The Redgate's Pay-option is not available to me b/c we are a small NFF company.

    I finally found the FREE auto-complete product at ApexSQL that works wonderfully, much better than intellisense so far!

    If you want to hear my latest experience with it, feel free to drop me a note (long.ng2000@gmail.com).

    Best,

    Long

  • May 22, 2015 at 8:05 am

    #1800011

    Ctrl+Shift+R will refresh the Intellisense local cache. (Or Edit > Intellisense > Refresh Local Cache.)

    See if that helps?

  • May 22, 2015 at 8:20 am

    #1800021

    Beatrix Kiddo (5/22/2015)

    Ctrl+Shift+R will refresh the Intellisense local cache. (Or Edit > Intellisense > Refresh Local Cache.)

    See if that helps?

    That has never helped me with the problem the op is describing but it does get rid of the red squiggly lines under objects I recently created in another session :hehe:

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 15 posts - 1 through 14 (of 14 total)

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