£35.47
  • RRP: £47.50
  • You Save: £12.03 (25%)
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Quantity:1
SQL Server 2012 Query Per... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) Paperback – 20 Jun 2012

Save an extra 10% with Amazon Student*

5.0 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£35.47
£31.30 £32.20
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more

*Save an extra 10% on this product with Amazon Student
From 28 June, 2016, Amazon Student members will receive an extra 10% off 1000s of selected books. The Offer will be automatically applied to your order at checkout. This Offer ends at 23:59pm BST on 16 October, 2016. Terms & Conditions apply. Learn more
£35.47 FREE Delivery in the UK. In stock. Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions

  • Amazon Students Members Get an Extra 10% Off Selected Books Here's how (terms and conditions apply)

Frequently Bought Together

  • SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server)
  • +
  • Microsoft SQL Server 2012 Internals
Total price: £61.75
Buy the selected items together

Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.




Product details

  • Paperback: 532 pages
  • Publisher: Apress; 3 edition (20 Jun. 2012)
  • Language: English
  • ISBN-10: 1430242035
  • ISBN-13: 978-1430242031
  • Product Dimensions: 19 x 3 x 23.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 620,296 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

About the Author

pstrongGrant Fritchey/strong works as a development database administrator for FM Global, an industry-leading engineering and insurance company. In his previous time as a database administrator and developer, he has worked at three failed dot-coms, a major consulting company, and a global bank. He has developed large-scale applications in languages such as VB, C#, and Java and has lived with SQL Server from the hoary days of 6.0, right through to 2008. His nickname at work is "The Scary DBA." He even has an official name plate, and he displays it proudly. /p pGrant volunteers for the Professional Association of SQL Server Users (PASS) and has written and published articles on various topics relating to SQL Server at Simple-Talk, SQL Server Central, SQL Server Performance, the PASS web site, SQL Standard, and the SQL Server Worldwide Users Group. He is the author of the book emDissecting SQL Server Execution Plans/em. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG)./p pOutside work, Grant kayaks, learns and teaches self-defense, brews his own beer, chops wood to heat his house, raises his kids, and helps lead a pack of Cub Scouts./p


Customer Reviews

5.0 out of 5 stars
5 star
2
4 star
0
3 star
0
2 star
0
1 star
0
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
This is an excellent book, written to accompany SQL Server 2012 but a lot of the theory and recommendations equally apply to previous versions of SQL Server.

It's well structured, clearly written and will improve understanding of why things done one way are better than possible alternatives. Experienced DBAs or developers will find something to learn from this book, people new to the SQL Server or specifically T-SQL may need an intro to T-SQL to go hand-in-hand with this one as it is not set at an introductory level.

I have heard there were some early copies that Amazon managed to print with print-setting issues but they are offering free replacements for all of these so I have no issues with recommending it to anyone.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Hi,

I have written a chapter-by-chapter review of this book on "[...]" the first part of this review follows:

Indexes are a primary means of making performance improvements on SQL Server. This book aims to tell you all you need to know about indexes, and more importantly, provides a methodological approach to index tuning, turning what is often viewed as an art into a science.

Indexes are typically a dry subject matter, however they are fundamental to both understanding the structure of data and helping improve query performance. The examples provided make the subject interesting and accessible.

Before reading the book, I had a list of questions that I hoped would be covered, this would let me know how detailed the book was. It successfully answered most of my questions - showing me the book had both depth and quality. These questions included:

*Will it use practical examples to illustrate a point?

*Does it mention the plan cache as an input to the DTA?

*Does it identify the limit in the number of missing indexes?

*Will it tell me how to fix a corrupt index?

*Will it provide scripts to automatically optimize my databases?

I did wonder why anyone would want to write a book solely about indexes. After all, if you wanted to know about a given make of car, would you buy a book that's only about the car's engine? The answer I think, from a performance perspective, is yes.

Thanks
Ian
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse


Feedback