Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Best Editor To use Expand / Collapse
Author
Message
Posted Wednesday, April 9, 2008 12:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 7:02 PM
Points: 13, Visits: 132
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
Posted Wednesday, April 9, 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, August 19, 2014 10:01 AM
Points: 3,844, Visits: 3,841
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
Posted Wednesday, April 9, 2008 12:16 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 7:02 PM
Points: 13, Visits: 132
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
Posted Wednesday, April 9, 2008 12:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Posted Wednesday, April 9, 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, August 19, 2014 10:01 AM
Points: 3,844, Visits: 3,841
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
Posted Wednesday, April 9, 2008 12:29 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 7:02 PM
Points: 13, Visits: 132
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
Posted Wednesday, April 9, 2008 12:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 7:02 PM
Points: 13, Visits: 132
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
Posted Wednesday, April 9, 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, August 19, 2014 10:01 AM
Points: 3,844, Visits: 3,841
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
Posted Wednesday, April 9, 2008 1:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 6, 2014 7:02 PM
Points: 13, Visits: 132
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
Posted Wednesday, April 9, 2008 2:34 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:09 PM
Points: 15,662, Visits: 28,053
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 12»»

Permissions Expand / Collapse