Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Intellisense Expand / Collapse
Author
Message
Posted Friday, May 16, 2008 6:34 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 25, 2014 1:01 PM
Points: 2,716, Visits: 2,466
I've just started to trial SQL2008 CTP6 (version 10.0.1300.13).

One of the features I was looking forward to was Intellisense, but it hasn't matched my expectations.

It wasn't so much the list of objects, or functions that I wanted to use Intellisense for, but more for things like the list of parameters for a function. For example, I can never remember the correct order of the parameters for SUBSTRING, or for REPLACE, and I was hoping that intellisense would at least give me a helpful hint, but it just lists, for example, "Param1 varchar, Param3 varchar, Param5 varchar" for REPLACE.

I *know* there are 3 parameters needed, one for the string to search in, one for the string to find, and one for the string to replace with BUT it's the order I forget!!!

Post #501985
Posted Friday, May 16, 2008 8:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 13,776, Visits: 28,178
I wasn't entirely happy with it either. Not too to be salesman, but Red Gate's SQL Prompt does everything you're looking for. I'm still planning on using it going forward.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #502077
Posted Friday, May 30, 2008 1:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:50 AM
Points: 1,190, Visits: 604
You may need to wait for next release :) to get what exactly you are looking for...
MS provides the functionaliyt in instalments...:)


MohammedU
Microsoft SQL Server MVP
Post #509333
Posted Friday, May 30, 2008 3:03 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 2,907, Visits: 1,830
My first reaction on seeing the latest Microsoft SQL Intellisense was disappointment. It looked like a cut down version of SQL Prompt when SQL Prompt was a $20 app called PromptSQL.

SQL Prompt is a bit of a "Marmite" product. You either love it or hate it, there doesn't seem to be any middle ground. Personally I love it because it can do so much more than mere intellisense.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #509385
Posted Monday, June 2, 2008 5:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 13,776, Visits: 28,178
SQL Prompt does take some practice to get used to it being involved with your TSQL. I've gotten rather good at hitting the 'Esc' key when I know it's just getting in my way.

Maybe more functionality will be included in the final release.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #509752
Posted Monday, June 2, 2008 11:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:06 PM
Points: 31,078, Visits: 15,524
There is another release of 2008 slated soon, which should update things a bit. I work for Red Gate, and haven't compared them, but many people seem to love SQL Prompt.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #510072
Posted Tuesday, June 3, 2008 6:47 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 26, 2014 6:02 AM
Points: 919, Visits: 1,434
SQL Prompt has too much overhead. The 2008 Intellisense seems much faster and less intrusive. Maybe I didn't use SQL Prompt long enough, but it was too annoying so I uninstalled it after a couple of days.

There's always pro's/con's, right?



Post #510599
Posted Tuesday, June 3, 2008 6:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 13,776, Visits: 28,178
Absolutely. Nothing is perfect. I do love SQL Prompt, but I recognize it's weaknesses. For example, I've had it, out of the blue, chew up all the system resources. It's only happened once or twice, but it was a serious pain. The other thing is, it's practically a Microsoft product. It tries way to hard to "help" me do stuff that I can do better on my own. Still, once you get addicted, it's like crack. I can't stand not having table & column names popping up on the fly as I type.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #510606
Posted Wednesday, June 4, 2008 3:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 29, 2010 8:59 AM
Points: 18, Visits: 27
Hi,

Steve - Can you recollect which version of SQL Prompt you had used and found these issues on?
SQL Prompt did have some performance issues with the older versions. However, we did address this issue in our recent versions and there has been a massive improvement which is visible in our current versions!

Grant - As far as the intrusiveness is concerned, SQL Prompt gives you an option to turn off the automatic triggerring (so that the suggestions do not get populated unless you manually force it to show using CTRL+SPACE). But then there is a downside of not being able to get the candidates (tables and columns) suggested automatically as I see that is something you love :)
Also, if there is a pattern or steps that you figured out to replicate the resource hog issue please do let us know!

We are currently working on planning tasks for SQL Prompt v4.0. This is a major version but since we are on the primitive stages of planning our tasks I am not in a position to announce any of the features or changes at this point of time. We will keep our forums (accessible from Red Gate support page) updated with announcements relating to this.

Thank you for all your comments (good and bad) on SQL Prompt :D

Regards,
Tanya
Red Gate Software Ltd
Post #511842
Posted Thursday, June 5, 2008 6:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:27 PM
Points: 13,776, Visits: 28,178
Thanks for the response Tanya. Like I say, I may whine a bit now & then, but I'm seriously addicted to your product.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #512038
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse