Intellisense Tools

• vinodajacob

  SSC Enthusiast

  Points: 111

  More actions

  July 22, 2016 at 5:57 am

  #400452

  Just wondering what everyone's take is on the Intellisense tools that are installed as add-ins to SSMS

  I personally think that the Devart SQLComplete tool is the best because it provides commands as well a the full table column listing with the ability to select multiple columns and it is very quick and easy to use.

  I was trying to use the APEX SQL Complete - which has almost all the same features as the Devart tool but it does not allow for multiple selection - and it is somewhat slow in generating results and sometimes crashes SSMS

  I have not tried RedGate SQL Prompt - hopefully some of you SQL gurus out there have possibly tried all these type of tools for SSMS and was wondering what the general opinion because you don't find this type of in depth reviews when searching online

  Thanks to anyone that responds and provides their feedback

  -Vinod

• Phil Parkin

  SSC Guru

  Points: 246819

  More actions

  July 22, 2016 at 6:38 am

  #1891537

  vinodajacob (7/22/2016)

  ---

  Just wondering what everyone's take is on the Intellisense tools that are installed as add-ins to SSMS

  I personally think that the Devart SQLComplete tool is the best because it provides commands as well a the full table column listing with the ability to select multiple columns and it is very quick and easy to use.

  I was trying to use the APEX SQL Complete - which has almost all the same features as the Devart tool but it does not allow for multiple selection - and it is somewhat slow in generating results and sometimes crashes SSMS

  I have not tried RedGate SQL Prompt - hopefully some of you SQL gurus out there have possibly tried all these type of tools for SSMS and was wondering what the general opinion because you don't find this type of in depth reviews when searching online

  Thanks to anyone that responds and provides their feedback

  -Vinod

  Apart from collapsible regions, fast connection-switching between servers/databases and a couple of minor things (for which I use SSMSBoost), SQL Prompt does everything I need and more. Wherever I go, I insist on using it.

  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

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  August 21, 2016 at 7:21 am

  #1896512

  +1 for SQL Prompt

  Recently rolled out copies to entire dev team including standard formatting styles to promote consistency across entire codebase.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• sean redmond

  SSCertifiable

  Points: 5823

  More actions

  August 22, 2016 at 1:33 am

  #1896565

  I'm a big fan of SQL Prompt too.

  I only have two complaints about it:

  a. I wish that I could create DB-specific or server-specific snippets and

  b. I wish that I could feed it one CSV (per DB naturally) with all of the snippets on it, instead of having to create each snippet individually.

  Aside from these 2 quibbles, I use it all of the time and recommend it to all whom I meet that use SQL Server often.