{"title":"Grant Fritchey","description":"\u003cp\u003eDelve into the world of SQL Server with Grant Fritchey, a seasoned expert. Discover insightful guides and resources for database professionals seeking to master their craft and optimise performance. Start your learning journey here.\u003c\/p\u003e","products":[{"product_id":"sql-server-2012-query-performance-tuning-book-grant-fritchey-9781430242031","title":"SQL Server 2012 Query Performance Tuning","description":"Put the principles and lessons from SQL Server 2012 Query Performance Tuning into practice today.  Establish performance baselines and monitor against them  Troubleshoot and eliminate bottlenecks that frustrate users  Plan ahead to achieve the right level of performance","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49526431908113,"sku":"GOR007934137","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50125390151953,"sku":"CIN1430242035G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52484381671697,"sku":"NLS9781430242031","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":53568588579089,"sku":"NIN9781430242031","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1430242035.jpg?v=1751084783"},{"product_id":"dissecting-sql-server-execution-plans-book-grant-fritchey-9781906434021","title":"Dissecting SQL Server Execution Plans","description":"Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: - Which indexes are being used, and where no indexes are being used at all. - How the data is being retrieved, and joined, from the tables defi ned in your query. - How aggregations in GROUP BY queries are put together. - The anticipated load and the estimated cost that all these operations place upon the system. Grant Fritchey's book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans. Sample chapters of the ebook have garnered stunning reviews, such as: All I can say is WOW. This has to be the best reference I have ever seen on Execution Plans in SQL Server. My hats off to Grant Fritchey Jonathan Kehayias.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49529215058193,"sku":"GOR006506584","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50478863221009,"sku":"CIN1906434026G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52480826179857,"sku":"NLS9781906434021","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":52755624001809,"sku":"NIN9781906434021","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1906434026.jpg?v=1750996755"},{"product_id":"sql-server-execution-plans-book-grant-fritchey-9781906434939","title":"SQL Server Execution Plans","description":"Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? An execution plan describes what's going on behind the scenes when SQL Server executes a query. It shows how the query optimizer joined the data from the various tables defined in the query, which indexes it used, if any, how it performed any aggregations or sorting, and much more. It also estimates the cost of all of these operations, in terms of the relative load placed on the system. Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans.My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":49778214142225,"sku":"GOR006754960","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ WELL_READ \/ SBYB","offer_id":50402347680017,"sku":"CIN190643493XA","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ NEW \/ INGRAM","offer_id":51055069888785,"sku":"NIN9781906434939","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":52107702665489,"sku":"CIN190643493XG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52676931191057,"sku":"NLS9781906434939","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/190643493X.jpg?v=1751281439"},{"product_id":"sql-server-query-performance-tuning-book-grant-fritchey-9781430267430","title":"SQL Server Query Performance Tuning","description":"Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey’s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques, especially including the newly-added, in-memory database features formerly known under the code name Project Hekaton. This book provides the tools you need to approach your queries with performance in mind.   SQL Server Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You’ll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You’ll learn to 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, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server Query Performance Tuning into practice today.    Covers the in-memory features from Project Hekaton Helps establish performance baselines and monitor against them Guides in troubleshooting and eliminating of bottlenecks that frustrate users","brand":"WoB","offers":[{"title":"US \/ VERY_GOOD \/ SBYB","offer_id":50453240021265,"sku":"CIN1430267437VG","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":50763965169937,"sku":"CIN1430267437G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50812056305937,"sku":"GOR011317405","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1430267437.jpg?v=1750794237"},{"product_id":"sql-server-2017-query-performance-tuning-book-grant-fritchey-9781484238875","title":"SQL Server 2017 Query Performance Tuning","description":"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.","brand":"WoB","offers":[{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":50618086654225,"sku":"GOR012473216","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ GOOD \/ SBYB","offer_id":51281693802769,"sku":"CIN1484238877G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ GOOD \/ INTERNAL","offer_id":53425709809937,"sku":"GOR014914800","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1484238877.jpg?v=1751179615"},{"product_id":"sql-server-2022-query-performance-tuning-book-grant-fritchey-9781484288900","title":"SQL Server 2022 Query Performance Tuning","description":"Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. These modern features are covered while still providing the necessary fundamentals to better understand how statistics and indexes affect query performance. The book gives you knowledge and tools to help you identify poorly performing queries and understand the possible causes of that poor performance. The book also provides mechanisms for resolving the issues identified, whether on-premises, in containers, or on cloud platform providers. You’ll learn about key fundamentals, such as statistics, data distribution, cardinality, and parameter sniffing. You’ll learn to analyze and design your indexes and your queries using best practices that ward off performance problems before they occur. You’ll also learn to use important modern features, such as Query Store to manage and control execution plans, the automated performance tuning feature set, and memory-optimized OLTP tables and procedures. You will be able to troubleshoot in a systematic way. Query tuning doesn’t have to be difficult. This book helps you to make it much easier.    What You Will Learn  Use Query Store to understand and easily change query performance Recognize and eliminate bottlenecks leading to slow performance Tune queries whether on-premises, in containers, or on cloud platform providers Implement best practices in T-SQL to minimize performance risk Design in the performance that you need through careful query and index design Understand how built-in, automatic tuning can assist your performance enhancement efforts Protect query performance during upgrades to the newer versions of SQL Server    Who This Book Is For Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks (including how to identify them, understand them, and eliminate them)","brand":"WoB","offers":[{"title":"US \/ NEW \/ INGRAM","offer_id":51029515993361,"sku":"NIN9781484288900","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"US \/ GOOD \/ SBYB","offer_id":51326338040081,"sku":"CIN1484288904G","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52455946092817,"sku":"NLS9781484288900","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1484288904.jpg?v=1751404851"},{"product_id":"sql-server-execution-plans-book-grant-fritchey-9781910035245","title":"SQL Server Execution Plans","description":"\u003cp\u003eIf a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.\u003cbr\u003e \u003c\/p\u003e\u003cp\u003eI wrote this book with the singular goal of teaching you how to read SQL Server Execution plans\u003cbr\u003e \u003c\/p\u003e\u003cp\u003eIt will explain, among many other things, the following: \u003cbr\u003e \u003c\/p\u003e \u003cul\u003e \u003cli\u003eHow to capture execution plans using manual and automatic methods\u003c\/li\u003e \u003cli\u003eA documented method for reading and interpreting execution plans\u003c\/li\u003e \u003cli\u003eHow common SQL Server objects, such as indexes, views, stored procedures, and so on, appear in execution plans\u003c\/li\u003e \u003cli\u003eHow to control execution plans with hints and plan guides, and why this is a double-edged sword\u003c\/li\u003e \u003cli\u003eHow the Query Store works with, and collects data on, execution plans\u003cbr\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWith this knowledge, you'll have everything you need to read the execution plan, for any query of your own, regardless of complexity, and understand what it does and what is causing the bad performance. It is still your job to work out how best to fix it, but your new understanding of execution plans will give a much better chance of success \u003c\/p\u003e","brand":"WoB","offers":[{"title":"- \/ - \/ -","offer_id":51054725562641,"sku":"","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":51054728151313,"sku":"NIN9781910035245","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ VERY_GOOD \/ INTERNAL","offer_id":51850063773969,"sku":"GOR013334516","price":0.0,"currency_code":"GBP","in_stock":false},{"title":"GB \/ NEW \/ INGRAM","offer_id":52590649737489,"sku":"NLS9781910035245","price":0.0,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/1910035246.jpg?v=1751187676"},{"product_id":"sql-server-2025-query-performance-tuning-book-grant-fritchey-9798868818646","title":"SQL Server 2025 Query Performance Tuning","description":"A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.   The fundamentals are still here: You’ll learn how statistics and indexes impact performance, how to identify poorly performing queries, and how to discover effective solutions. But this new edition also includes advanced features unique to SQL Server 2025, such as AI integration for automatic tuning, insights on using extended events, automatic execution plan correction, and more. It’s a must-have resource designed to empower you to troubleshoot slow-performing queries and make them run faster than ever.   The book is a treasure trove of instruction, insight, and advice. As you dive in, you’ll encounter key fundamentals, from statistics and data distribution to cardinality and parameter sniffing, and learn to analyze and design your indexes and queries using best practices that prevent performance problems before they occur. You’ll also explore advanced features like Query Store for managing and controlling execution plans, automated performance tuning, and memory-optimized OLTP tables and procedures—and learn how SQL Server 2025 makes it all more powerful and automatable than ever.   What You Will Learn     Use Query Store to understand and easily change query performance Recognize and eliminate bottlenecks leading to slow performance Tune queries whether on-premises, in containers, or on cloud platform providers Implement best practices in T-SQL to minimize performance risk Design in the performance that you need through careful query and index design Understand how built-in, automatic tuning can assist your performance enhancement efforts Protect query performance during upgrades to the newer versions of SQL Server   Who This Book Is For   Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks—including how to identify them, understand them, and eliminate them","brand":"WoB","offers":[{"title":"GB \/ NEW \/ GARDNERS","offer_id":53613122126097,"sku":"NGR9798868818646","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"GB \/ NEW \/ INGRAM","offer_id":53639768703249,"sku":"NLS9798868818646","price":0.0,"currency_code":"GBP","in_stock":true},{"title":"US \/ NEW \/ INGRAM","offer_id":53664063815953,"sku":"NIN9798868818646","price":0.0,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0784\/4072\/6801\/files\/9798868818646.jpg?v=1780316515"}],"url":"https:\/\/www.worldofbooks.com\/en-au\/collections\/author-books-by-grant-fritchey.oembed","provider":"World of Books ","version":"1.0","type":"link"}