Will it be usefull for SQL 2005 If I purchase a book on performance tuning for SQL 2008 ?

  • Hi All,

    I am planning to purchase a book on 'Performance Tuning'. We have only SQL Server 2005 here. Since I want to upgrade myself, thinking of buying a book on SQL 2008. But priority is to mainitain all these SQL 2005 database here.

    So will it be usefull for SQL 2005 If I purchase a book on performance tuning for SQL 2008 ? Or is it going to be totally different for SQL 2005 ? Please guide.

    Also can you please suggest some useful titles pls...

    Thanks in advance ?

  • There may be a few minor performance-tuning differences between 2005 and 2008, but the vast majority of the data will be applicable to both. The differences between the two are minor in that regard.

    I'd start with any of the books on this site: http://www.red-gate.com/our-company/about/book-store/

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Thank you so much. Am clear now. Will go through the books you mentioned.

    .......... I am bit worried that you are the only one responded to my post. ............... From a Microsoft SQL Server community of 1,387,736 DBAs,developers and SQL Server users 🙂 🙂

    Thanks.

  • Joy Smith San (5/10/2011)


    .......... I am bit worried that you are the only one responded to my post. ............... From a Microsoft SQL Server community of 1,387,736 DBAs,developers and SQL Server users 🙂 🙂

    Everyone else reads GSquared reply first, notices that it satisfies the question more then enough and leaves the thread be.

    There is no use in repeating the same answer over and over 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Edit: double post

    (quite ironic when the original post is about not posting the same thing twice :hehe:)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Joy Smith San (5/10/2011)


    Thank you so much. Am clear now. Will go through the books you mentioned.

    .......... I am bit worried that you are the only one responded to my post. ............... From a Microsoft SQL Server community of 1,387,736 DBAs,developers and SQL Server users 🙂 🙂

    Thanks.

    Part of relational theory for databases is that you shouldn't have repeating rows of data, so, as database addicts, we tend to try to avoid "me too" type posts on this site. 🙂

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • ... Excellant.... That makes us "Normalized"..!! 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

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