Query Store for SQL Server 2019

Query Store for SQL Server 2019

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. Query Store helps to…

SQL Server 2017 Query Performance Tuning, 5th Edition

SQL Server 2017 Query Performance Tuning, 5th Edition

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….

SQL Server Query Performance Tuning, 4th Edition

SQL Server Query Performance Tuning, 4th Edition

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…

Pro SQL Server 2012 Practices

Pro SQL Server 2012 Practices

Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance – but also branching into release management, auditing, and…

SQL Server 2012 Query Performance Tuning, 3rd Edition

SQL Server 2012 Query Performance Tuning, 3rd Edition

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 optimization features and techniques. It…