Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Learn T-SQL Querying A guide to developing efficient and elegant T-SQL code

Product type Paperback

Published in May 2019

Publisher Packt

ISBN-13 9781789348811

Length 484 pages

Edition 1st Edition

Languages

SQL

Tools

T-SQL

Concepts

Database Administration

Authors (2):

Pedro Lopes

Pam Lahoud

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Query Processing Fundamentals FREE CHAPTER

2. Anatomy of a Query

3. Understanding Query Processing

4. Mechanics of the Query Optimizer

5. Section 2: Dos and Donts of T-SQL

6. Exploring Query Execution Plans

7. Writing Elegant T-SQL Queries

8. Easily-Identified T-SQL Anti-Patterns

9. Discovering T-SQL Anti-Patterns in Depth

10. Section 3: Assemble Your Query Troubleshooting Toolbox

11. Building Diagnostic Queries Using DMVs and DMFs

12. Building XEvent Profiler Traces

13. Comparative Analysis of Query Plans

14. Tracking Performance History with Query Store

15. Troubleshooting Live Queries

16. Managing Optimizer Changes with the Query Tuning Assistant

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Tracking Performance History with Query Store

This chapter will introduce the Query Store, which is effectively a flight recorder for SQL Server T-SQL executions, allowing performance tracking over time and analysis of workload trends through rich UI reports that are included with SSMS.

We will also see how the Query Store integrates with the Query Plan Comparison, which was covered in Chapter 10, Comparative Analysis of Query Plans, for a complete UI-driven workflow for query performance insights.

This chapter covers the following topics:

The Query Store
Tracking expensive queries
Fixing regressed queries

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at AU $24.99/month. Cancel anytime

Authors (2)

Pedro Lopes

Pedro Lopes is a Program Manager in the Database Systems group, based in Redmond, WA, USA. He has over 19 years of industry experience and has been with Microsoft for 9 years. He is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Relational Engine. He has extensive experience with query performance troubleshooting and is a regular speaker at numerous conferences such as SQLBits, PASS Summit, SQLIntersection, Microsoft Ignite, and Microsoft Build. He blogs about SQL on the SQL Server Team blog. He has authored several tools in the Tiger toolbox on GitHub: AdaptiveIndexDefrag maintenance solution, BPCheck, and usp_WhatsUp.

See other products by Pedro Lopes

Lahoud

Pam Lahoud is a Program Manager in the Database Systems group, based in Redmond, WA, USA. She has been with Microsoft for 13 years and is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Storage Engine area. She is passionate about SQL Server performance and has focused on performance tuning and optimization, particularly from the developer's perspective, throughout her career. She is a SQL Server 2008 Microsoft Certified Master (MCM) with over 20 years of experience working with SQL Server.

See other products by Lahoud