A copy that has been read, but remains in clean condition. All pages are intact, and the cover is intact (including dust cover, if applicable). The spine may show signs of wear. Pages can include limited notes and highlighting, and the copy can include "From the library of" labels or limited small stickers. Book may have a remainder mark or be a price cutter.

N� de ref. del art�culo A-03-04-05-0437

Contactar al vendedor

Denunciar este art�culo

Detalles bibliogr�ficos

T�tulo: SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Editor: Apress
Fecha de publicaci�n: 2018
Idioma: Ingl�s
ISBN 10: 1484238877
ISBN 13: 9781484238875
Encuadernaci�n: Encuadernaci�n de tapa blanda
Edici�n: 5� Edici�n o Posterior
Estado: Good

Acerca de

Sinopsis

1. SQL Query Performance Tuning

2. Memory Performance Analysis

3. Disk Performance Analysis

4. CPU Performance Analysis

5. Creating a Baseline

6. Query Performance Metrics

7. Analyzing Query Performance

8. Index Architecture and Behavior

9. Index Analysis

10. Database Engine Tuning Advisor

11. Query Store

12. Key Lookups and Solutions

13. Statistics, Data Distribution, and Cardinality

14. Index Fragmentation

15. Execution Plan Generation

16. Execution Plan Cache Behavior

17. Parameter Sniffing

18. Query Recompilation

19. Query Design Analysis

20. Reduce Query Resource Use

21. Blocking and Blocked Processes

22. Causes and Solutions for Deadlocks

23. Row-By-Row Processing

24. Memory-Optimized OLTP Tables and Procedures

25. Automated Tuning in Azure SQL Database and SQL Server

26. Database Performance Testing

27. Database Workload Optimization

28. SQL Server Optimization Checklist

Acerca del autor

Grant Fritchey, Microsoft Data Platform MVP, has more than 20 years of experience in IT. That time was spent in technical support, development, and database administration. He currently works as Product Evangelist at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books, including SQL Server Execution Plans and SQL Server 2012 Query Performance Tuning (Apress). He has written chapters for Beginning SQL Server 2012 Administration (Apress), SQL Server Team-based Development, SQL Server MVP Deep Dives Volume 2, Pro SQL Server 2012 Practices (Apress), and Expert Performance Indexing in SQL Server (Apress). Grant currently serves as President on the Board of Directors of the PASS organization, the leading source of educational content and training on the Microsoft Data Platform.

"Sobre este t�tulo" puede pertenecer a otra edici�n de este libro.

Descripci�n de la librer�a

The Idaho Youth Ranch provides services which help at-risk youth in Idaho that are in our residential treatment facilities or are part of our many non-residential services. We provide PROMISING FUTURES for these youth and their families and it could not be accomplished with out people like you willing to purchase our items to support these services.

Ver la p�gina web de la librer�a

Informaci�n empresarial del vendedor

Idaho Youth Ranch Books
5465 W Irving, Boise, ID, 83706, U.S.A.

Condiciones de venta y env�o

Condiciones de venta

We offer a 100% satisfaction guarantee.

Idaho Youth Ranch Books
5465 W. Irving Street
Boise, ID 83706
sales@idahoyouthranchbooks.com

Condiciones de env�o

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.