-
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Author Grant Fritchey
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 accumu....
Release Date 2022/11 -
Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries
Author Grant Fritchey , Tracy Boggiano
Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server.Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Q....
Release Date 2019/10 -
SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Author Grant Fritchey
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 bottle....
Release Date 2018/09 -
Expert Performance Indexing in SQL Server, Second Edition
Author Grant Fritchey , Jason Strate
This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into th....
Release Date 2015/10 -
SQL Server Query Performance Tuning,Fourth Edition
Author Grant Fritchey
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 ....
Release Date 2014/09 -
SQL Server 2012 Query Performance Tuning, Third Edition
Author Grant Fritchey
Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance ....
Release Date 2012/06 -
Beginning SQL Server 2012 Administration
Author Grant Fritchey , Rob Walters
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It's an ideal book for those new to database administration, as well for those moving to SQL Server fro....
Release Date 2012/05 -
Beginning SQL Server 2008 Administration
Author Carmen Taglienti , Grant Fritchey , Robert E. Walters
Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. This book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.
Release Date 2009/10 -
SQL Server 2008 Query Performance Tuning Distilled
Author Grant Fritchey , Sajal Dam
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble-shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedi....
Release Date 2009/03