Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Best Editor To use
Add to briefcase
15 posts, Page 1 of 2
12»»

Best Editor To use Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Marcin Wilczek
Posted Wednesday, April 09, 2008 12:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:14 AM
Points: 11, Visits: 113
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.
Post #482531
John Rowan
Posted Wednesday, April 09, 2008 12:12 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821
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
Post #482534
Marcin Wilczek
Posted Wednesday, April 09, 2008 12:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:14 AM
Points: 11, Visits: 113
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.
Post #482535
GSquared
Posted Wednesday, April 09, 2008 12:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571
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
Post #482542
John Rowan
Posted Wednesday, April 09, 2008 12:29 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821
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
Post #482548
Marcin Wilczek
Posted Wednesday, April 09, 2008 12:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:14 AM
Points: 11, Visits: 113
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.
Post #482549
Marcin Wilczek
Posted Wednesday, April 09, 2008 12:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:14 AM
Points: 11, Visits: 113
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.
Post #482552
John Rowan
Posted Wednesday, April 09, 2008 12:57 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821
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
Post #482566
Marcin Wilczek
Posted Wednesday, April 09, 2008 1:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:14 AM
Points: 11, Visits: 113
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.
Post #482587
Grant Fritchey
Posted Wednesday, April 09, 2008 2:34 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 13,383, Visits: 25,189
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #482617
« Prev Topic | Next Topic »

Add to briefcase
15 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.