Post reply

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

  • March 20, 2014 at 7:14 pm

    #305560

    I am already looked on msdn website.

    Please provide me some more.

    thanks.

  • March 20, 2014 at 8:29 pm

    #1698932

    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)

  • March 20, 2014 at 11:17 pm

    #1698945

    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."

  • March 21, 2014 at 5:13 am

    #1699029

    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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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