Nevarez SQL Server Query Tuning and Optimization

Optimize Microsoft SQL Server 2022 queries and applications
1. Auflage 2022
ISBN: 978-1-80323-978-1
Verlag: De Gruyter
Format: EPUB
Kopierschutz: 0 - No protection

E-Book, Englisch, 446 Seiten

No detailed description available for "SQL Server Query Tuning and Optimization".

Autoren/Hrsg.

Nevarez, Benjamin

Fachgebiete

• Mathematik | Informatik EDV | Informatik Daten / Datenbanken
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmier- und Skriptsprachen
• Mathematik | Informatik EDV | Informatik Technische Informatik Server

Inhaltsverzeichnis

Table of Contents - An Introduction to Query Tuning and Optimization
- Troubleshooting Queries
- The Query Optimizer
- The Execution Engine
- Working with Indexes
- Understanding Statistics
- In-Memory OLTP
- Understanding Plan Caching
- The Query Store
- Intelligent Query Processing
- An Introduction to Data Warehouses
- Understanding Query Hints

Über Autor(innen)

Nevarez Benjamin:

Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of several books including “High Performance SQL Server'', “SQL Server 2017 on Linux”, “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and has also co-authored other books such as “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences around the world