Shop top categories that ship internationally
Buy New
EUR64.14
EUR 9.84 delivery Wednesday, May 13
Ships from: Amazon.com
Sold by: Amazon.com
EUR 64.14
No Import Charges & EUR 9.84 Shipping to Netherlands Details

Shipping & Fee Details

Price EUR 64.14
AmazonGlobal Shipping EUR 9.84
Estimated Import Charges EUR 0.00
Total EUR 73.98

EUR 9.84 delivery Wednesday, May 13
Or fastest delivery Monday, May 11. Order within 1 hr 15 mins
Only 1 left in stock - order soon.
EUR EUR 64.14 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 64.14
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Shipper / Seller
Amazon.com
Amazon.com
Shipper / Seller
Amazon.com
Returns
30-day refund / replacement
30-day refund / replacement
Quick refund
Usually issued within 24 hours. See exceptions
Shipping fee
May apply, not eligible for free return. See details
Convenient dropoff
At any of our 50,000 US locations.
See return policy
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
EUR 32.43
This item is at an Amazon warehouse waiting to be shipped to you by Amazon. We do this to provide the best shipping experience. In the very unlikely event of something goes wrong with your order, Amazon will provide service and process a return, if necessary. This item is at an Amazon warehouse waiting to be shipped to you by Amazon. We do this to provide the best shipping experience. In the very unlikely event of something goes wrong with your order, Amazon will provide service and process a return, if necessary. See less
EUR 9.84 delivery Wednesday, May 13
Or fastest delivery Monday, May 11. Order within 3 hrs 40 mins
Only 1 left in stock - order soon.
EUR EUR 64.14 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 64.14
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Follow the author

Get new release updates & improved recommendations
Grant Fritchey
Follow
Something went wrong. Please try your request again later.

SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance 5th ed. Edition

by Grant Fritchey (Author)
4.7 out of 5 stars (54)
{"desktop_buybox_group_1":[{"displayPrice":"EUR 64.14","priceAmount":64.14,"currencySymbol":"EUR","integerValue":"64","decimalSeparator":".","fractionalValue":"14","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"Wd%2FZ5nf78YX9vW2RhSuulEwR7dFS%2FdZf00DaejsS26ElaR7tWfJ87LVsp1tJsbgoWw6F51SV3QZsduXrs6Ai9a%2FCxhZzY7D5hAXm4xc1iYiIABWw8pnNr7A0EgTNXLamkCC2IinKkfKFQcRcQBNpXQ%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"EUR 32.43","priceAmount":32.43,"currencySymbol":"EUR","integerValue":"32","decimalSeparator":".","fractionalValue":"43","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"Wd%2FZ5nf78YX9vW2RhSuulEwR7dFS%2FdZfallABKmonKuhLRsnkxMnCObAE3XcSp92bb2zNdK9pEk0RSVOfZkmibD%2BOpFpIXFLRs3KRODZSfHqVo7PyYlNjDAUh2c1qxHPeqhw%2BCOf89JJYfXWM2rGexrEzeyohacBg8IRIqjEJqku9Xz1pn5yDA%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

This book covers the latest in performance optimization features and techniques and is current with SQL Server 2017. If your queries are not running fast enough and you’re tired of phone calls from frustrated users, then this book is the answer to your performance problems.

SQL Server 2017 Query Performance Tuning is about more than quick tips and fixes. You’ll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and Extended Events. You’ll recognize bottlenecks and defuse them before the phone rings. You’ll learn some quick solutions too, but emphasis is on designing for performance and getting it right. The goal is to head off trouble before it occurs.


What You'll Learn

  • Use Query Store to understand and easily change query performance
  • Recognize and eliminate bottlenecks leading to slow performance
  • Deploy quick fixes when needed, following up with long-term solutions
  • Implement best practices in T-SQL to minimize performance risk
  • Design in the performance that you need through careful query and index design
  • Utilize the latest performance optimization features in SQL Server 2017
  • Protect query performance during upgrades to the newer versions of SQL Server


Who This Book Is For

Developers and database administrators with responsibility for application performance in SQL Server environments. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

Read more
Previous slide of product details
  1. ISBN-10
    1484238877
  2. ISBN-13
    978-1484238875
  3. Edition
    5th ed.
  4. Publisher
    Apress
  5. Publication date
    September 4, 2018
  6. Language
    English
  7. Dimensions
    7 x 0.75 x 10 inches
  8. Print length
    963 pages
Next slide of product details

Editorial Reviews

From the Back Cover

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.

This book covers the latest in performance optimization features and techniques and is current with SQL Server 2017. If your queries are not running fast enough and you’re tired of phone calls from frustrated users, then this book is the answer to your performance problems.

SQL Server 2017 Query Performance Tuningis about more than quick tips and fixes. You’ll learn to be proactive in establishing performance baselines using tools such as Performance Monitor and Extended Events. You’ll recognize bottlenecks and defuse them before the phone rings. You’ll learn some quick solutions too, but emphasis is on designing for performance and getting it right. The goal is to head off trouble before it occurs.

What You'll Learn:

  • Use Query Store to understand and easily change query performance
  • Recognize and eliminate bottlenecks leading to slow performance
  • Deploy quick fixes when needed, following up with long-term solutions
  • Implement best practices in T-SQL to minimize performance risk
  • Design in the performance that you need through careful query and index design
  • Utilize the latest performance optimization features in SQL Server 2017
  • Protect query performance during upgrades to the newer versions of SQL Server

About the Author

Grant Fritchey, Microsoft Data Platform MVP, has more than 20 years of experience in IT. That time was spent in technical support, development, and database administration. He currently works as Product Evangelist at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books, including SQL Server Execution Plans and SQL Server 2012 Query Performance Tuning (Apress). He has written chapters for Beginning SQL Server 2012 Administration (Apress), SQL Server Team-based Development, SQL Server MVP Deep Dives Volume 2, Pro SQL Server 2012 Practices (Apress), and Expert Performance Indexing in SQL Server (Apress). Grant currently serves as President on the Board of Directors of the PASS organization, the leading source of educational content and training on the Microsoft Data Platform.

Product details

  • Publisher ‏ : ‎ Apress
  • Publication date ‏ : ‎ September 4, 2018
  • Edition ‏ : ‎ 5th ed.
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 963 pages
  • ISBN-10 ‏ : ‎ 1484238877
  • ISBN-13 ‏ : ‎ 978-1484238875
  • Item Weight ‏ : ‎ 3.66 pounds
  • Dimensions ‏ : ‎ 7 x 0.75 x 10 inches
  • Best Sellers Rank: #2,482,498 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.7 out of 5 stars (54)

About the author

Follow authors to get new release updates, plus improved recommendations.
Grant Fritchey

Grant Fritchey

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Grant Fritchey, Microsoft Data Platform MVP, has more than thirty years experience in IT. That time was spent in technical support, development and database administration. Grant currently works as a Product Advocate at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books including, "SQL Server Execution Plans" and "SQL Server 2022 Query Performance Tuning." Grant co-authored the book "Introduction to PostgreSQL" along with Ryan Booz. Grant presents on a variety of topics at user groups and conferences around the world.

Related books

Page 1 of 1Start Over
Sponsored
Previous page
  1. Shop the Store on Amazon ›
    Computer Networking Bible: [3 in 1] The Complete Crash Course to Effectively Design, Implement and Manage Networks. Including Sections on Security, Performance and Scalability
    Computer Networking Bible: [3 in 1] The Complete Crash Course to Effectively Design, Implement and Manage Networks. Including Sections on Security, Performance and Scalability
    4.24.2 out of 5 stars288
    EUR28.20
  2. Shop the Store on Amazon ›
    Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
    Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
    4.64.6 out of 5 stars511
    31% offLimited time deal
    EUR32.46 List:EUR47.04
  3. Shop the Store on Amazon ›
    SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)
    SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL (Coding & Programming - QuickStart Guides)
    4.64.6 out of 5 stars1,845
    EUR18.18 List:EUR23.94
  4. Shop the Store on Amazon ›
    Python Programming for Beginners: The Complete Guide to Mastering Python in 7 Days with Hands-On Exercises – Top Secret Coding Tips to Get an Unfair Advantage and Land Your Dream Job!
    Python Programming for Beginners: The Complete Guide to Mastering Python in 7 Days with Hands-On Exercises – Top Secret Coding Tips to Get an Unfair Advantage and Land Your Dream Job!
    4.44.4 out of 5 stars1,069
    EUR21.38
  5. Shop the Store on Amazon ›
    Python Programming for Beginners: The Complete Python Coding Crash Course - Boost Your Growth with an Innovative Ultra-Fast Learning Framework and Exclusive Hands-On Interactive Exercises & Projects
    Python Programming for Beginners: The Complete Python Coding Crash Course - Boost Your Growth with an Innovative Ultra-Fast Learning Framework and Exclusive Hands-On Interactive Exercises & Projects
    4.54.5 out of 5 stars1,022
    EUR17.02
Next page

Customer reviews

4.7 out of 5 stars
54 global ratings

Top reviews from the United States

  • Amazon Customer
    5.0 out of 5 stars Learned a lot
    Reviewed in the United States on May 15, 2020
    Format: KindleVerified Purchase
    Great book, I learned a lot. When learning a topic as sophisticated as this, sequence and reference backs to spots in the book is important. He did a good job with this. Plenty of examples and actionable as well. He also had some opinions about what to use caution with but not biased to "his" way of doing things.
    2 people found this helpful
    Helpful
     Report
  • Ian Stirk
    5.0 out of 5 stars If you want a good, wide ranging, SQL code optimization book, I can certainly recommend this book.
    Reviewed in the United States on October 31, 2018
    Format: Paperback
    Conclusion

    This book covers a wide range of performance topics and techniques, with the central aim of improving the performance of your SQL workload. It is generally easy to read, with practical step-by-step walkthroughs, helpful links between chapters and to websites, and good use of screenshots. Typically, code is provided to back up the assertions made. The book should take your level of expertise from level 3 to level 8 (based on a 1 to 10 scale).

    While this book covers most code-based performance topics, there were times when I wanted more detail. There was no mention of the more advanced performance tools like SQLDIAG or SQL Nexus. Sometimes the structure of the book felt awkward (e.g. perfMon is explained in the memory chapter but its example usage is given in a later chapter). Having a separate detailed tools chapter, that is repeatedly referenced, may have been better.

    This book is very similar to the 2014 edition of the book, while the screenshots have been updated for 2017, the text is perhaps 70% the same or similar (2 new chapters have been added). Although written for SQL Server 2017, much is applicable to 2014 and earlier. If you want a good, wide ranging, SQL code optimization book, I can certainly recommend this book.
    11 people found this helpful
    Helpful
     Report
  • Anthony
    3.0 out of 5 stars Good refresher and reference
    Reviewed in the United States on October 12, 2021
    Format: PaperbackVerified Purchase
    Bought this book as a refresher and reference guide to things I did not already know. Great for a beginner
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • ANDREIEV SOARES BARBOSA
    5.0 out of 5 stars Excelente livro
    Reviewed in Brazil on April 15, 2021
    Format: PaperbackVerified Purchase
    Excelente livro. Didática fácil de entender
    Report
  • Flash
    5.0 out of 5 stars Recomendado para DBA
    Reviewed in Spain on April 25, 2021
    Format: PaperbackVerified Purchase
    Como administrador de bases de datos buscaba un libro que me ayudara en mi trabajo y me diera otro enfoque ante problemas de performance-rendimiento.
    La verdad es que estoy encantado, las explicaciones son claras y los ejemplos ayudan un montón. Toca todo tipo de herramientasy temas: vistas dinamicas, performance monitor, index, trazas...
    Ademas hay scripts muy útiles válidos para usar en el día a dia.
    Lo único es que considero que debes
    una buena base para entender el libro, ya que no esta hecho para principiantes.
    Customer image
    Flash
    5.0 out of 5 stars
    Recomendado para DBA

    Reviewed in Spain on April 25, 2021
    Como administrador de bases de datos buscaba un libro que me ayudara en mi trabajo y me diera otro enfoque ante problemas de performance-rendimiento.
    La verdad es que estoy encantado, las explicaciones son claras y los ejemplos ayudan un montón. Toca todo tipo de herramientasy temas: vistas dinamicas, performance monitor, index, trazas...
    Ademas hay scripts muy útiles válidos para usar en el día a dia.
    Lo único es que considero que debes
    una buena base para entender el libro, ya que no esta hecho para principiantes.
    Images in this review
    Customer image Customer image
    Report
See more reviews