I have a real love/hate relationship with DBArtisan. On the one hand, there's nothing like it for useful features. On the other the bugs are embarassingly bad. I'm currently running 8.5.5 to which I upgraded because the earlier version would scramble source code in the editor, an utterly unforgivable bug. The new version is less buggy, but I really have to wonder what the Embarcadero developers are smoking because I'd be ashamed of being associated with it. In additions to bugs others have mentione, here are a couple of my "favorite" examples:
The editing keys (copy, insert, etc.) are inconsistent between windows. Need to copy some code out of a stored procedure window into an iSQL window? Ctrl-C doesn't work in the source code window. It does everywhere else. Moreover, this changed from the earlier version. Get this right and lock it down. Don't go all Microsoft by "improving" basic function from version to version.
Speaking of editing, if you want to copy some results out of an ad-hoc query so as to insert it into Excel, well, that's hit-or-miss. Sometimes you get the data in columns, sometimes you get it as concatenated strings. I could be doing something wrong but, somehow, I doubt it.
Don't try search and replace in a script extract window. That results in an endless loop behavior with shutdown the only option.
Would it be too much to ask to put a Copy selection on the right-click context menu? Jeez, everyone else does this why not DBArtisan?
Then there's the incredibly useful data unload and load feature. I'm not being sarcastic here, it's damned useful. But I've learned the hard way not to dump to comma-separated files, the load feature can't read them!
I live in a Sybase world and while I actually like Sybase (don't even ask me about the miserable Sybase GUI tool, it's even worse), I long for the stability of the new SQL Server Management Studio. Compared to DBArtisan, it's rock-solid.
These issues may seem small, but when the query you've been tweaking for the last hour is lost in some window that's now inaccessable because DBArtisan has lost it, one tends to become very upset very quickly.