Comments
Sort by recent activity
Brian, thanks for the response - as with most sql tools products i use, they always seem to have a hard time with large databases --
i look forward to the maturing of this product to the level of the other tools i have used in the past... (i would worry though, if the cache is read completely into memory upon connecting to that db; in my case, i may run out of memory before even getting the benefits of localized cached version of my db schema...)
thanks again.... / comments
Brian, thanks for the response - as with most sql tools products i use, they always seem to have a hard time with large databases --
i look forward to the maturing of this product to the level of t...
let me also put the cache issue another way...
i have peoplesoft fms with 40k tables and 30k views... it has yet to cache the db correctly and renders the intellisense partially useless... maybe i should consider this an application bug instead?
thanks again.... / comments
let me also put the cache issue another way...
i have peoplesoft fms with 40k tables and 30k views... it has yet to cache the db correctly and renders the intellisense partially useless... maybe i...
1) with regard to the competitor product (aqua data) please take a minute to download the trial and at least see what i am talking about -- even without looking at the competitor i am requesting the following featureset:
the ability to not have it cache my db schema to my hard-drive; the ability to have it not auto-invoke intellisense (only when i press the key combo should it invoke - this is a common feature in most intellisense installs) - lastly, when i invoke the intellisense it uses only the data at hand to give me the results...
example - i type the following:
SELECT * FROM PS_RD_
with the cursor placed right after the second underscore, i press the key combo to invoke intellisense, at this point it queries the SYSOBJECTS table (or whatever your code does) and only brings back objects starting with "PS_RD_" -- this appears very fast in the competitors apps and should be very fast since the name column of sysobjects is indexed....
2) with regard to the X. example in my previous post - the intellisense window shows the column name AND the table name it comes from when i invoke intellisense -- i will go back and get a screen shot of the issue....
thanks for your time on this request - i love the product but it has issues with databases that have objects in the several thousands.... / comments
1) with regard to the competitor product (aqua data) please take a minute to download the trial and at least see what i am talking about -- even without looking at the competitor i am requesting th...
no response from red-gate? / comments
no response from red-gate?
i am not in front of an xp machine right now - but approximately this...
c:\documents and settings\your profile name\application data\local...\....[the rest of the path in the message above]
or you can just search your harddisk for the xml file name too... / comments
i am not in front of an xp machine right now - but approximately this...
c:\documents and settings\your profile name\application data\local...\....[the rest of the path in the message above]
or you...
i see in this forum the copy/paste has been reported for a while as an issue in the options-snippit window... i see its still not fixed...
is there any workaround - can i put it in a file on the local disk that prompt reads from? i would hate to type the lines i have to paste... / comments
i see in this forum the copy/paste has been reported for a while as an issue in the options-snippit window... i see its still not fixed...
is there any workaround - can i put it in a file on the lo...
Look for the file:
SQL Prompt 3 Snippets.xml
in Vista its in:
C:\Users\YOURUSER-SAMACCOUNTNAME\AppData\Local\Red Gate\SQL Prompt 3to make it easy i created a snippit thru the options screen just to get it to create all the nodes... then i went into the xml file and replaced the <Code> text.... I tested using the CDATA tag so that the xml parser wouldnt trip over my sql - it worked great.....
<Code>
<![CDATA[
YOUR SQL SNIPPIT GOES HERE
]]>
</Code> / comments
Look for the file:
SQL Prompt 3 Snippets.xml
in Vista its in:
C:\Users\YOURUSER-SAMACCOUNTNAME\AppData\Local\Red Gate\SQL Prompt 3to make it easy i created a snippit thru the options screen just to...
Lurks, so you went from Xpress Apps to Imceda then to Quest.... you have had a turbulant ride...
I loved the speed ide tool - getting a key from quest when you move the software to a new machine is painful - they dont understand what a perpetual software license is - but i digress...
what i really liked was that it could read ahead and behind and figure out the table allias for intellisense - i liked that you could delay the intelli until you prompted for it -- i work on peoplesoft dbs often and the FMS db from peoplesoft has 40,000 tables - it chokes every app except speed...
i also liked the two dropdowns to change SERVER and DB in the same window - what an awesome feature...
if you are stil at quest - i hope you can do your magic there - if not, i cant wait to see what you build whereever you are at now... / comments
Lurks, so you went from Xpress Apps to Imceda then to Quest.... you have had a turbulant ride...
I loved the speed ide tool - getting a key from quest when you move the software to a new machine i...
i sent a pm - however its in my outbox not my sentbox... i hope you received it... / comments
i sent a pm - however its in my outbox not my sentbox... i hope you received it...
they are officially retiring it - i was speaking with their support team when i moved my copy to another machine - they dont really understand the term 'perpetual license' (but i digress) - they wanted me to pay a maint fee to get the turn on code - then they also informed me that if i paid the fee i would get the next version of toad since they were sunsetting speed ide and that in a few months they would not be able to give me another turn on code if i moved my software to another machine again -- i asked if they were going to create a final version that doesnt need the turn-on code for those of us that expected 'perpetual license' to actually mean something for the version we do have - funny, they never responded to that one - it was supposed to go to management... hmmm
all this was about 6+ months ago now - i never went back to see if there is a newer version - but let me tell you, its hard to find anything for speed ide on their site...
anyway, i am glad to help anyway i can -- thanks for the quick reply!
Patrick / comments
they are officially retiring it - i was speaking with their support team when i moved my copy to another machine - they dont really understand the term 'perpetual license' (but i digress) - they wa...