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


SQL Prompt IntelliSense for SQL Server


SQL Prompt IntelliSense for SQL Server

Author
Message
cutiger93
cutiger93
SSC-Enthusiastic
SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)SSC-Enthusiastic (131 reputation)

Group: General Forum Members
Points: 131 Visits: 1

Bart,

Could you comment on license from the legacy version? I like this product and it has helped me an our developers do our job more efficiently. I am sure that some of the bugs will be worked out by you guys.





Pedro R. Lopez
Pedro R. Lopez
SSC Veteran
SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)

Group: General Forum Members
Points: 232 Visits: 140

On my case the program takes a lot of memory m and ussing version 2.0.0 , some times takes 128 MB of memory.



Pedro R. Lopez
http://madurosfritos.blogspot.com/
rob orchiston
rob orchiston
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 1

Tried it. Hated it. Uninstalled it. The look and feel is yuk. It looks like something that was written for windows 3.1. Maybe I didn't set it up right but it kept bugging me to log in, just when I was starting to write a bunch of SQL. It was more of a pain than a help. I would be interested in such a tool and would find features such as parameter order for functions like DatePart a benefit. It still needs some work in my view. I may take a look at subsequent releases.


DavidSimpson
DavidSimpson
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1266 Visits: 1081

Once of heard of this tool and the fact that in worked with Query analyzer and Ultra Edit made me want to try it out. But like many of the other responses, I found the tool to be rather buggy.

First the fact that the prompts work some of the time but not all of the time is rather annoying.

Also, when I prefix a table then begin typing in the "where" clause, SQL Prompt will bring up a list of all the columns rather then waiting until I enter the prefix. Once you press the dot it inserts the column that started with the same letter as the prefix (unless you type fast then it simply inserts the first column in the list). For example instead of "select * from TableA a where a.<list of columns>" I get "select * from TableA a where aColumn".

I've seen the performance hit mentioned before but after a few seconds it seemed to get better. Hopefully this will be improved in the next release.

So in the end not much time is safed by using this version because I must constantly undo and retype or check that not only if the prompt comes up but if it displaying the correct information. Maybe I didn't have it configured right but then again I really didn't want to spend a lot of time tweeking the tool just to get it to work correctly for a basic query.

I think the idea is great and will definitly revisit this when 3.0 is released, but even free is too much for me for the current version.

ds





Aaron Ingold
Aaron Ingold
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1513 Visits: 222
I tried this roughly 2-3 weeks ago and found a lot of the same issues. Using it was extremely slow and it consumed a great deal of system resources. While it might help with database schema, one thing I like about intellisense generators is that they save me time in typing out long lists of columns, etc... This one definitely didn't. While I've been a huge fan of Red Gate's products in the past, I think this one needs to mature a little bit before I'll get all that excited about it.

Not to hawk another product here, but I was using ApexSQL Edit for a while which has similar functionality and seemed to be better performing. However that product had its own problems with memory leaks and stability in other areas. I'm wondering if they've fixed those yet.
Calvin Lawson
Calvin Lawson
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1180 Visits: 102
I tried this product a month ago. The CPU utilization goes up to 99% when it's sucking all the relational data in, but it drops back down after that. Which is pretty much fine, although kind of brutish.

But I uninstalled it anyway. Maybe I'm just a fast coder, but it's way to slow! If they speed it up it could be pretty cool.

Signature is NULL
Aaron Dutton
Aaron Dutton
SSC Veteran
SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)SSC Veteran (245 reputation)

Group: General Forum Members
Points: 245 Visits: 88
I have to agree with the majority of posters here. I installed it but haven't really found it to be beneficial.

It hasn't been a real resource hog that I've noticed, but it just doesn't work that well. I just expect different things than it is listing while I type. Overall I find that it doesn't save any time or keystrokes because it is never suggesting what I'm looking for.



jereme.guenther@gmail.com
jereme.guenther@gmail.com
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1109 Visits: 194

I do alot of development in addition to writting SQL code and have really gotten hooked on intellisence. I know that in a perfect world, rules would be followed so all the naming conventions were the same. As it stands we have multiple naming conventions in place, which makes it very difficult to remember exactly what convention was used for a given database or table. Also in SQL2000 (probubly 2005 as well), when writing SQL code you had to ensure that you were writing case sensitive code if you wanted SQL server to be able to reuse its execution plans correctly. Having intellisense helps me get things done right.

However, I have worked in SQL for so long without intelisense that I wouldn't be all that handycapped not to have it.

I haven't taken the time to customize my menus yet so I won't comment on that one. The one annoying bug I have found so far is in SQL2005's management studio. It occurs when I open a table, select a column name from the criteria pane, and press tab to move off of the selection. Management studio freezes for several seconds before a I get a .NET runtime error which asks me if I want to terminate the program or continue with it. So far I have just told it to ignore the error and continue which has worked fine, however I have tried to cut down on my use of the tab key in this area. I did try going into SQL Prompts options and disabled the tab key. This fix didn't work at the time, however I have recently rebooted my computer and can't recreate the problem so maybe it is fixed now.


John Scarborough
John Scarborough
Old Hand
Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)

Group: General Forum Members
Points: 392 Visits: 52

A few points:

An early beta of Yukon (first beta iirc) did indeed have intellisense. It was awesome.

SQL Prompt was resource intensive so even though it was very cool, I quit using it. No problem, I can live without it, but I liked the idea.

And as to the complaint of some people that intellisense is intrusive, unnecessary, whatever: turn it off if you don't like it. I don't know of any development app where you can't turn it off if you want to, but for me, it's useful to be able to browse through all the methods, function, properties, etc, and darned handy to save typing.



John Scarborough
MCDBA, MCSA
jereme.guenther@gmail.com
jereme.guenther@gmail.com
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1109 Visits: 194

That would have been great, bummer they took it out. I know they removed it because of a time crunch but do you know if they are planning on adding it back in with a service pack?


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