T-SQL Querying - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

T-SQL Querying

Author

Topic

latinmusic74
Starting Member

6 Posts

Posted - 2009-08-19 : 10:53:37

Does a DBA needs to know T-SQL Querying?

Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-08-19 : 11:12:52

yes.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!

latinmusic74
Starting Member

6 Posts

Posted - 2009-08-19 : 11:30:34

Why?

In which task of DBA does T-SQL is use?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-08-19 : 11:45:21

Might as well ask if a doctor needs to know medicine.

latinmusic74
Starting Member

6 Posts

Posted - 2009-08-19 : 11:50:58

quote:
Originally posted by robvolk

Might as well ask if a doctor needs to know medicine.

Can you provide examples where a DBA use T-SQL?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-08-19 : 11:59:39

- Making backups.
- Updating statistics.
- Rebuilding or defragmenting indexes.
- Archiving or cleaning up data.

Every administrative action in SQL Server is ultimately accomplished using T-SQL commands. The GUI simply translates the user input into the correct T-SQL.

latinmusic74
Starting Member

6 Posts

Posted - 2009-08-19 : 12:12:15

quote:
Originally posted by robvolk

- Making backups.
- Updating statistics.
- Rebuilding or defragmenting indexes.
- Archiving or cleaning up data.

Every administrative action in SQL Server is ultimately accomplished using T-SQL commands. The GUI simply translates the user input into the correct T-SQL.

For those tasks, I believe there are graphical tools to do it.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-08-19 : 12:15:22

Please re-read what I said about that.

latinmusic74
Starting Member

6 Posts

Posted - 2009-08-19 : 12:38:00

quote:
Originally posted by robvolk

Please re-read what I said about that.

Then you do not really need to know t-sql. let the server and the gui do the job.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2009-08-19 : 13:13:11

good luck with that.

___________________________________________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.5 out!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-19 : 14:32:05

A whole lot of sql admin tasks are coded (with t-sql) and scheduled to run so you don't need to sit there 24/7 doing incremental backups, or come in every Sunday morning at 2:00 AM to update statistics and maintain indexes etc.

Also, if you suddenly get a bunch of application errors (like timeouts for instance) you need to be able to identify what is causing it and fix the problem right away. That process will (almost always) involve reading and/or writing t-sql.

EDIT:
If you can learn to play latin music, you can learn to code t-sql. It's practically the same thing :)

Be One with the Optimizer
TG

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-08-19 : 14:41:49

Are you by any chance acquainted with user: rudba ?

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources