Does anyone have anything to say about this product? I won a copy from SSC and I've given it a little go over the last few weeks, but it's not lived up to my expectations.
Simple things don't seem to work consistently and this is very frustrating. For example, the software regularly 'forgets' that I have told it not to auto-start when QA opens. As it takes too long to initialise a database, this gets very annoying as I keep having to reach for the off button.
The software also has trouble remembering my preferences for formatting etc, so when I do use it I find that all my T-SQL appears in upper case and I then have to trawl the menu to sort that out.
As this is such basic functionality, I'm wondering if there is a problem with my PC not remembering these changes, but no other software has this trouble.
The performance of SQL Prompt is what has prompted me to finally stop using the software. It takes an age to initialise, even if I open a new QA window that is connecting to an already initialised DB, that I'd rather switch it off than wait. I've also found that when switched on it interfers with the movement of the cursor, as it jerks about when scrolling/moving through T-SQL queries. Perhaps I can overcome this by more careful tuning of the options? But, if it isn't going to remember those options then I can't see me using it again.
EDIT: Re-reading this, I've made it sound like SQL Prompt is rubbish and doesn't work: This isn't the case. It works very well when initialised, but the simple problems highlighted above are enough to put me off using it.
A bunch of at work downloaded the 14 day trial yesterday to play with. The idea in theory is great but the implimentation is poor.
I didn't notice any issues with it forgetting settings. Our main beef is the performance.
It seems that it was constantly "indexing" itself. Every time i opened a new query window it would pop up and start "indexing" and it usually took 5 to 10 minutes to do that. durring the time my systems was being bogged down and SSMS would lock up ocasionally in the middle of me typing. Not to mention the 15-20mb of ram it was constantly using.
I'll be the first to admit out database structure needs a good cleaning up. We have over 3500 tables, 3000 views and 2000 stored procedures in our main production database.
I think that perhaps we have a bit too large of a system for it to efficently manage all the data it needs to work with.
We did have high hopes and were planing to buy a 10 license pack but i don't think we will now. We still might get 1 to give to new programmers so they have a nice quick reference to help learn our system.
Maybe they'll work on the performance and we'll come back and take another look at version 4.
Thanks for the update Bart!
FYI, my system a 2.2ghz p4 (original p4s) with a gig of ram. not a barnstormer by any means but i like to think no slouch either.
I'll put a note in my calendar to check back and retry the new build in a month or so. Like I said the idea is great and I'd love to have a tool to help me write some nice clean SQL.
Thanks for the excellent response, Bart.
I've checked the UIOptions.xml and EngineOptions.xml files and they do update when I make changes to SQL Prompt options. I'm going to check with the IT guys here to see if there is something wrong with my profile that is making it 'forget' these changes.
The DB I use mostly is over 50GB in size, so it does take a fair amount of time to initialise. However, the things you mentioned for the new version sound like they'll definitely help matters, so I'll be giving that a go.
And just to re-iterate, SQL Prompt works very well apart from the niggles I have mentioned, and the WOW factor when I showed it to a colleague was most impressive
Well, it now gets more or less bizarre, depending on your view, because this morning SQL Prompt has remembered all my settings from yesterday.
I'll keep monitoring it each day and see if I can pin down the exact scenario that settings are lost.