SQL Server Query Tuning and Optimization

Idioma: inglés

Editorial: Packt Publishing Limited, GB, 2022

1803242620 / 9781803242620

  • Tapa blanda
  • Nuevo
Ver todos los detalles

Librería: Rarewaves.com UK, London, Reino UnidoRarewaves.com UK

Vendedor de 5 estrellas

Vendedor de IberLibro desde 11 de junio de 2025

Tapa blanda

Condición: Nuevo

EUR 65,97

Envío por EUR 77,15 
Se envía de Reino Unido a Estados Unidos de America

Cantidad disponible: Más de 20 disponibles

Añadir al carrito
Devoluciones gratuitas de 30 días

Descripción del artículo del vendedor

Get well-versed with ready-to-use techniques for creating high-performance queries and applicationsKey FeaturesSpeed up queries and dramatically improve application performance by both understanding query engine internals and practical query optimizationUnderstand how the query optimizer worksLearn about intelligent query processing and what is new in SQL Server 2022Book DescriptionSQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.This book starts 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 it needs to produce efficient execution plans. As you progress, you'll get practical query optimization tips for troubleshooting underperforming queries. The book will also guide you through intelligent query processing and what is new in SQL Server 2022. Query performance topics such as the Query Store, In-Memory OLTP and columnstore indexes are covered as well.By the end of this book, you'll be able to get the best possible performance for your queries and applications.What you will learnTroubleshoot queries using methods including extended events, SQL Trace, and dynamic management viewsUnderstand how the execution engine and query operators workSpeed up queries and improve app performance by creating the right indexesDetect and fix cardinality estimation errors by examining query optimizer statisticsMonitor and promote both plan caching and plan reuse to improve app performanceTroubleshoot and improve query performance by using the Query StoreImprove the performance of data warehouse queries by using columnstore indexesHandle query processor limitations with hints and other methodsWho this book is forThis book is for SQL Server developers who are struggling with slow query execution, database administrators who are tasked with troubleshooting slow application performance, and database architects who design SQL Server databases in support of line-of-business and data warehousing applications.…

N° de ref. del artículo LU-9781803242620

Título
SQL Server Query Tuning and Optimization
Autor
Benjamin Nevarez
Editorial
Packt Publishing Limited, GB
Año de publicación
2022
Estado
New
Encuadernación
Paperback
Idioma
inglés
ISBN 10
1803242620
ISBN 13
9781803242620

Rarewaves.com UK

London, Reino Unido

Vendedor de 5 estrellas

Vendedor de IberLibro desde 11 de junio de 2025

Tarifas de envío de Reino Unido a Estados Unidos de America

ArtículoDe 60 a 60 días hábilesDe 60 a 60 días hábiles
Primer artículoEUR 77,15EUR 118,69
Los plazos de entrega los establecen los vendedores y varían según el transportista y la ubicación. Los pedidos que pasan por la aduana pueden sufrir retrasos y los compradores son responsables de los aranceles o tarifas asociadas. Los vendedores pueden ponerse en contacto con usted en relación con cargos adicionales para cubrir cualquier aumento en los costes de envío de los artículos.

Métodos de pago

  • Visa
  • Mastercard
  • American Express
  • Carte Bleue
  • Apple Pay
  • Google Pay

Información empresarial del vendedor

RAREWAVES.COM LIMITED

Elsley Court, 20-22 Great Titchfield Street
London, Reino Unido W1W 8BE