SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: What's best for DBAs? GUI or T-SQL commands?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 09/04/2002 :  11:46:20  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Narayana Vyas Kondreddi submitted "This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourslef, if you want to be a point-and-click DBA or a T-SQL scripting expert!"

Article Link.

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 09/04/2002 :  13:15:43  Show Profile  Visit nr's Homepage  Reply with Quote
Haven't read the above but using the gui doesn't allow you to save a record of what you have done so never use it for updates.
Maybe for creating databases but I don't even do that.

For enquiries - maybe it is ok now - 6.5 it used to take locks so was pretty damaging to a production system.
I use it for seeing if scheduled tasks are scheduled/running sometimes but that's about it.
Sends a lot of data so not so good over a slow remote connection.

Do almost everything in a query window and if you are just looking at a production system make sure you execute
set transaction isolation level read uncommitted
first.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 09/04/2002 :  19:20:26  Show Profile  Visit Merkin's Homepage  Reply with Quote
quote:

What's best for DBAs? GUI or T-SQL commands?



Why do IT people have to be so one sided ?

I think the answer to the question of tools is "both". Use both, depending on what is most efficient for the task at hand.

Just because one thing is good does not make something else bad.

Damian
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 09/04/2002 :  21:45:31  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
quote:

Why do IT people have to be so one sided ?

I think the answer to the question of tools is "both". Use both, depending on what is most efficient for the task at hand.

Just because one thing is good does not make something else bad.


Isn't that essentially what VyasKn has said in the article?

I agree. And I like this article because it points out some of the strengths of EM and also some of its weaknesses. Seems pretty well-balanced writing.

Edited by - ajarnmark on 09/04/2002 21:47:39
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 09/04/2002 :  22:09:14  Show Profile  Visit Merkin's Homepage  Reply with Quote
Oooppps, I pulled an NR and commented before reading it

Damian

Edited by - Merkin on 09/04/2002 22:11:02
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000