Any good reference article/post where I can find SQL SERVER 2005/2008 administration commands?

Question

Any good reference article/post where I can find SQL SERVER 2005/2008 administration commands?

Learner44

SSCarpal Tunnel

Points: 4466
More actions
March 20, 2014 at 7:14 pm

#305560

I am already looked on msdn website.
Please provide me some more.
thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

Learner44 (3/20/2014)
I am already looked on msdn website.
Please provide me some more.
thanks.

If you load up "Books Online" (the help system that you can download for SQL Server) and the lookup "Administer" in the "look for" field of the index, you'll find more commands and other information for administering SQL Server than you can shake a stick at.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

free_mascot One Orange Chip Points: 27168 More actions · Answer 2

As mention by Jeff MS SQL BOOKS ONLINE is the perfect place to get all the informations required for SQL ADMIN. However it also depends what exectly you are looking for in what sense.

Find the below link which might help you:

http://www.diademblogs.com/database/some-useful-sql-commands-for-ms-sql-db-admins

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 3

I'm curious what you mean by administration commands? Except for the direct manipulation of data within the tables (and even that) almost every single command is going to be an "administration" command. Can you clarify what it actually is you're looking for?

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software