SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Intellisense


Intellisense

Author
Message
kevriley
kevriley
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3116 Visits: 2618
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!!!
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39757 Visits: 32639
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 and SQL Server Execution Plans
Product Evangelist for Red Gate Software
MohammedU
MohammedU
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1866 Visits: 812
You may need to wait for next release Smile to get what exactly you are looking for...
MS provides the functionaliyt in instalments...Smile

MohammedU
Microsoft SQL Server MVP
David.Poole
David.Poole
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7580 Visits: 3284
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
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39757 Visits: 32639
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 and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62450 Visits: 19102
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
My Blog: www.voiceofthedba.com
Steve-3_5_7_9
Steve-3_5_7_9
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1456 Visits: 1599
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?



Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39757 Visits: 32639
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 and SQL Server Execution Plans
Product Evangelist for Red Gate Software
tanya.joseph
tanya.joseph
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
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 Smile
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 BigGrin

Regards,
Tanya
Red Gate Software Ltd
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39757 Visits: 32639
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 and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search