Intellisense

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Intellisense

26 posts, Page 1 of 3

1 2 3 »»»

Intellisense

Rate Topic

Display Mode

Topic Options

Author

Message

kevriley

Posted Friday, May 16, 2008 6:34 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

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

Grant Fritchey

Posted Friday, May 16, 2008 8:02 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 13,381, Visits: 25,166

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #502077

MohammedU

Posted Friday, May 30, 2008 1:05 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 1:53 PM
Points: 1,190, Visits: 499

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

David.Poole

Posted Friday, May 30, 2008 3:03 PM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:35 AM
Points: 2,749, Visits: 1,407

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

Post #509385

Grant Fritchey

Posted Monday, June 02, 2008 5:26 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 13,381, Visits: 25,166

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #509752

Steve Jones - SSC Editor

Posted Monday, June 02, 2008 11:08 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

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

Steve-3_5_7_9

Posted Tuesday, June 03, 2008 6:47 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 810, Visits: 1,195

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

Grant Fritchey

Posted Tuesday, June 03, 2008 6:54 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 13,381, Visits: 25,166

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #510606

tanya.joseph

Posted Wednesday, June 04, 2008 3:59 PM

Grasshopper

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

Grant Fritchey

Posted Thursday, June 05, 2008 6:04 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 7:59 AM
Points: 13,381, Visits: 25,166

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 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 »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions