Get familiar with ready-to-use techniques for creating high-performance queries and applications.
1. Main features:
- ✓ Accelerate queries and significantly improve application performance by understanding query engine internals and actual query optimization.
- ✓ Understand how query optimizer works.
- ✓ Learn about intelligent query processing and what's new in SQL Server 2022.
2. Book description:
SQL Server is a relational database management system developed by Microsoft. As a database server, this is a software product whose main function is to store and retrieve data as required by other software applications.
This book begins by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information needed to create create effective implementation plans. As you progress, you'll get practical query optimization tips to troubleshoot inefficient queries. The book will also guide you through intelligent query processing and what's new in SQL Server 2022. Query performance topics such as Query Store, In-Memory OLTP, and columnstore indexing are also covered.
By the end of this book, you will be able to achieve the best possible performance for your queries and applications.
3. What you will learn:
- ✓ Troubleshoot queries using methods including extended events, SQL Trace, and dynamic management views.
- ✓ Understand how the execution engine and query operators work.
- ✓ Speed up queries and improve application performance by creating appropriate indexes.
- ✓ Detect and fix cardinality estimation errors by checking query optimizer statistics.
- ✓ Monitor and drive both plan caching and plan reuse to improve application performance.
- ✓ Troubleshoot and improve query performance using Query Store.
- ✓ Improve the performance of data warehouse queries using columnstore indexes.
- ✓ Handle query processor limitations with other suggestions and methods.
4. Who is this book for:
This book is for SQL Server developers struggling with slow query execution, database administrators tasked with troubleshooting slow application performance, and database architects designing SQL Server databases to Supports business and warehousing applications.
Index:
- ✓ Chapter 01. Introduction to Query Tuning and Optimization.
- ✓ Chapter 02. Troubleshooting queries.
- ✓ Chapter 03. Query Optimizer.
- ✓ Chapter 04. Execution Engine.
- ✓ Chapter 05. Working with Indexes.
- ✓ Chapter 06. Understanding Statistics.
- ✓ Chapter 07. In-Memory OLTP.
- ✓ Chapter 08. Learn Plan Caching.
- ✓ Chapter 09. Query Store.
- ✓ Chương 10. Intelligent Query Processing.
- ✓ Chapter 11. Introduction to Data Warehouses.
- ✓ Chapter 12. Understanding Query Hints.