SQL Server Query Performance Tuning: Distilled - Softcover

Dam, Sajal

Softcover

ISBN 10: 159059164X ISBN 13: 9781590591642

Verlag: Apress, 2003

Inhaltsangabe

Queries are one of the fundamental tools for manipulating data within SQL Server, and knowledge o f them is a necessity. This book uses a focused and practical approach to provide you with the most efficient methods to employ with queries. It focuses on the means SQL Server provides to understand the cost of a query, and provides recommendations for ways to remedy poorly-performing queries.

All the information provided is based on the author's real-world experience and highlights the most cost-effective situations to everyday use of SQL Server. He details the steps that you can follow to troubleshoot and resolve SQL query performance.

SQL Server Query Performance Tuning Distilled shows you:

How to identify problematic SQL queries

How to analyze a query execution plan

How to evaluate the effectiveness of the current indexing techniques

How to evaluate the effectiveness of statistics

How to analyze and avoid stored procedure recompilation

How to analyze plan caching

How to analyze and minimize blocking

How to analyze and avoid deadlocks

How to analyze the cost of using a specific cursor type

Details zur Ausgabe

• Verlag: Apress
• Erscheinungsdatum: 2003
• Sprache: Englisch
• ISBN 10: 159059164X
• ISBN 13: 9781590591642
• Einband: Taschenbuch
• Auflage: 1
• Anzahl der Seiten: 555
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: KreGa Onlinehandel GmbH; 4950000000000; info@krega-onlinehandel.de; ; Birkenweg 31; Brakel; 33034; Deutschland