Architechure

  • Hi All,

    I am new to SQL Server 2005 Administration. Can any one please refer me for "SQL Server 2005 Architechure" books....

    Regards,

    Austin

  • Actually, the help system in SQL Server is pretty good. Comes free with SQL Server. It's called "Books Online".

    --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)

  • As Jeff mentions, start from here:

    http://msdn2.microsoft.com/en-us/library/ms130214.aspx

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • Also, you may want to consider

    Inside Microsoft® SQL Server™ 2005: The Storage Engine

    by

    Kalen Delaney (Solid Quality Learning)

    (http://www.microsoft.com/MSPress/books/7436.aspx)

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • Thanks to all.....

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

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