wood burning stoves*
The moose likes JDBC and the fly likes IDE for Sql Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "IDE for Sql Server" Watch "IDE for Sql Server" New topic
Author

IDE for Sql Server

Alana Sparx
Ranch Hand

Joined: Feb 14, 2006
Posts: 121
Any recommendations?

Query Analyser I have found to be a primitive piece of rubbish.

I've tried Squirrel-Sql, and although it supports nifty functions (like code complete, returning metadata and rowcounts) it has the annoying habit of endlessly writing to its heapdump logfile until I kill the process if it encounters errors / sql statements that generate large result sets. These errors can be as simple as the connection to the DB no longer existing. Latterly I tried an outer join on two table with 1 million+ rows apiece. THis should be manageable, yes?

Help!
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

SQuirrel SQL doesn't give me this problem. Could you not just set the log level to fatal and the problem would go away?

That aside, I can't think of an editor that wouldn't struggle if you are trying to return records sets containing millions of results.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: IDE for Sql Server