Post reply

Good books (advanced) on query optimization/tuning

  • August 27, 2009 at 6:41 pm

    #204107

    Hello!

    I would like to purchase good book about query optimization strategies (choosing optimal indexes, writing efficient TSQL, etc.) and overall performance tuning strategies for SQL Server 2005. I am looking for advanced level.

    Any advice is greatly appreciated.

    Thanks,

    Igor

  • August 27, 2009 at 8:39 pm

    #1046019

    Grant Fritchey, who contributes a ton of time helping people here on SSC wrote a couple of ebooks that you can download for free right here on SSC:

    SQL Server Execution Plans [/url]

    I've got an ebook version of "Dissecting SQL Server Execution Plans", which i think is an earlier version of the book above; it jumped from 181 pages to 250 pages.

    Easy to read, and will really help you towards understanding how to improve SQLs and how it works behind the scenes.

    Also pay attention to some of the Red Gate advertisements; they offer free ebooks on various subjects all the time as well; i think that's where i got the earlier version of his execution plan book.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • August 27, 2009 at 11:17 pm

    #1046046

    Grant also wrote a full (paper) book on Query tuning - SQL Server 2008 Query performance tuning distilled (or something like that). Also check out the last of the Inside SQL Server 2005 series - query tuning and optimisation

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 28, 2009 at 6:25 am

    #1046141

    I'd recommend the Inside SQL Server series. You'll be hard pressed to find better information. Specifically I'd suggest getting "T-SQL Querying" by Itzik Ben-Gan, "The Storage Engine" by Kalen Delaney & "Performance Tuning & Optimization" by various authors. I'm not entirely crazy about the "T-SQL Programming" book in the series. It's good, but I don't think it's quite as useful as the others.

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

  • August 28, 2009 at 6:27 am

    #1046143

    Lowell (8/27/2009)

    Grant Fritchey, who contributes a ton of time helping people here on SSC wrote a couple of ebooks that you can download for free right here on SSC:

    SQL Server Execution Plans [/url]

    I've got an ebook version of "Dissecting SQL Server Execution Plans", which i think is an earlier version of the book above; it jumped from 181 pages to 250 pages.

    Easy to read, and will really help you towards understanding how to improve SQLs and how it works behind the scenes.

    Also pay attention to some of the Red Gate advertisements; they offer free ebooks on various subjects all the time as well; i think that's where i got the earlier version of his execution plan book.

    Same version on the Execution plan book. It's just not available for free any more. I suspect it's a difference in font & layout that changed the page count. When I was finished it was 192 in Word.

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

  • August 28, 2009 at 11:49 am

    #1046363

    Thanks all of you for advice!

    Igor

  • August 30, 2009 at 1:48 am

    #1046580

    Here is one more good book for ya: "Professional SQL Server 2005 Performance Tuning" from Wrox.

    I've put my paws on it just few weeks ago, I still have a couple of chapters to read, but overall, it is a good book.

    -------------------------------------------------------------
    "It takes 15 minutes to learn the game and a lifetime to master"
    "Share your knowledge. It's a way to achieve immortality."

  • August 30, 2009 at 9:13 am

    #1046617

    Thanks!

  • August 31, 2009 at 1:50 pm

    #1047110

    D.Oc (8/30/2009)

    Here is one more good book for ya: "Professional SQL Server 2005 Performance Tuning" from Wrox.

    I've put my paws on it just few weeks ago, I still have a couple of chapters to read, but overall, it is a good book.

    +1 on that one

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • September 2, 2009 at 12:20 pm

    #1048347

    Please try SQL TUNNING.....one of the best books I have read....and I have read all of the above mentioned whch are very good as well.

    The Book describes how to tell if the current plan is actually good or not and how to fix the execution plan to what it should be ......instead most book just tell you this is how you read the plan and now do the hunt peck method on how to fix it.

    This book solves the problem and eliminates the guess work of tuning?

    good luck

  • September 6, 2009 at 12:31 pm

    #1049892

    like others - i suggest "Inside SQL Server..." - these books are really good!

  • September 6, 2009 at 4:37 pm

    #1049927

    Grant Fritchey (8/28/2009)

    I'd recommend the Inside SQL Server series. You'll be hard pressed to find better information. Specifically I'd suggest getting "T-SQL Querying" by Itzik Ben-Gan, "The Storage Engine" by Kalen Delaney & "Performance Tuning & Optimization" by various authors. I'm not entirely crazy about the "T-SQL Programming" book in the series. It's good, but I don't think it's quite as useful as the others.

    Couldn't agree more. The mentioned books are pretty much the only ones you'll need - though T-SQL Programming is less in-depth than the others, and more of an intermediate-level text.

    The 2008 version was slightly disappointing in that it contains much of the same content as some of the 2005 volumes, covers less ground, and has no coverage of many 2008-specific features (like hierarchy ID and spatial data types).

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 6, 2009 at 8:14 pm

    #1049955

    Here's the link to Grant's latest book, which I can highly recommend: http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_3?ie=UTF8&s=books&qid=1252289317&sr=1-3

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • September 7, 2009 at 6:30 am

    #1050082

    Paul White (9/6/2009)

    Couldn't agree more. The mentioned books are pretty much the only ones you'll need - though T-SQL Programming is less in-depth than the others, and more of an intermediate-level text.

    The 2008 version was slightly disappointing in that it contains much of the same content as some of the 2005 volumes, covers less ground, and has no coverage of many 2008-specific features (like hierarchy ID and spatial data types).

    Really? That's a bit of a disappointment. I hadn't picked up the 2008 version, but I was planning to. You might have just saved me a bit of cash. Thanks.

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

  • September 7, 2009 at 2:47 pm

    #1050221

    Grant Fritchey (9/7/2009)

    Really? That's a bit of a disappointment. I hadn't picked up the 2008 version, but I was planning to. You might have just saved me a bit of cash. Thanks.

    Yes it was slightly disappointing - and I was really excited when it arrived too. Maybe the previous series just set my expectations too high. You are welcome to have a flick through my copy before deciding to splash out - next time you're passing :laugh:

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 15 posts - 1 through 15 (of 15 total)

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