SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Best Editor To use


Best Editor To use

Author
Message
Marcin Wilczek
Marcin Wilczek
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 137
Hey all,

I need advice on what is a good Text Editor to use for TSQL development.
I know there are tons out there, TextPad, UltraEdit, Notpad++, etc. But most of those seem to be more geared toward regular coding, and not many have extensions for SQL 2005, they tend to stop at SQL 2000 or earlier.

I know that its as much a personal preference as functionality, but i would like to hear some opinions of one app over others.

Basically what i will need this for is as stated, TSQL development in a SQL 2005 and future versions of the MS SQL platform.
I will also need something that will work well with Powershell. This is not a necessity but it would be nice to have as I need to start learning.

Anyway your thoughs and opinions are appreciated.
John Rowan
John Rowan
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5986 Visits: 4547
What's wrong with using Management Studios for your T-SQL coding?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Marcin Wilczek
Marcin Wilczek
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 137
I use it for now, but i want something that opens faster and has some of the nice text editor features.
Basically I want the best of both worlds.
I know this may be asking a lot but I really hate using more then one editor unless I truly have to and I hate that it bogs down my system a bit when i have it opened.
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23313 Visits: 9730
You might give RedGate's Prompt a try. Or ApexSQL Edit. They're both built for coding SQL.

Anything more powerful than Notepad will almost certainly cost some system resources, but I can't say I've had it matter for me.

Right now, I'm running SQL Server Dev, the client for Norton AV Enterprise, a few other background/services, Outlook 2003, IE 7, and Management Studio, but not running any local queries or jobs, and I'm at 2% CPU (Pentium D), and 2.5 Gig RAM (with SQL Server taking 1.7 of that) (out of 3.5 Gig available). Management Studio is more resource-hungry than Query Analyzer, and takes longer to fire up, but it's not that big a deal to me.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
John Rowan
John Rowan
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5986 Visits: 4547
What features are you looking for? If all you want is intellisense, use SQL Prompt as G2 suggested.

Are you saying that having Management Studios open bogs down your system? How so? Simply having it open should not have any effect on system performance.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Marcin Wilczek
Marcin Wilczek
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 137
I agree, I have been using the management studio, and the main reason why i asked about some of the other editors out there is that I would like to be able to use them to replace notpad as well and I do need to do some powershell coding in the near future, so I would not like to be bound by SQL only editors. I will try the ones mentioned and if i must I will use an editor made extensively for SQL and then use on of the other 3rd party editors for other coding projects.
Marcin Wilczek
Marcin Wilczek
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 137
Mainly formatting and syntax highlighting are key.

Simply having it open does not really do much to my system, but after a while my system does start to slowdown, and every bit of RAM is necessary. I have a lot of things on my system, since I do a lot of IT, and Database work. I wish the company got me a second system so that i can seperate DBA and IT/Net Admin.
John Rowan
John Rowan
SSCertifiable
SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)SSCertifiable (6K reputation)

Group: General Forum Members
Points: 5986 Visits: 4547
Have you went through all of the new formatting/style settings in Management Studios?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Marcin Wilczek
Marcin Wilczek
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 137
I have been playing with other editors and mostlikely i will stick with Notepad++ for all my text editing needs, and stick with Management studio, since i doubt my company will pay 200 for SQL Prompt.

I hate the delay it takes to open up, especially when i simply want to check out a script or a procedure i have in file.
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39255 Visits: 32616
Because we use DBPro (aka DataDude) I do a lot of TSQL programming in Visual Studio. It's not terribly good, but the integration with TFS & DBPro makes it necessary.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search