• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

IDE for Sql Server

 
Alana Sparx
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic