August 27, 2009 at 6:41 pm
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
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
August 27, 2009 at 11:17 pm
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
August 28, 2009 at 6:25 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 28, 2009 at 6:27 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 28, 2009 at 11:49 am
Thanks all of you for advice!
Igor
August 30, 2009 at 1:48 am
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
Thanks!
August 31, 2009 at 1:50 pm
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
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
like others - i suggest "Inside SQL Server..." - these books are really good!
September 6, 2009 at 4:37 pm
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).
September 6, 2009 at 8:14 pm
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
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 7, 2009 at 2:47 pm
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:
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy