SQL SERVER QUERY PERFORMANCE TUNING: Distilled - Softcover

CURLINGSTONE

 
9781590591642: SQL SERVER QUERY PERFORMANCE TUNING: Distilled
Softcover
ISBN 10: 159059164X ISBN 13: 9781590591642
Verlag: Sdu Uitgevers, 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

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Reseña del editor

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

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
Sdu Uitgevers
Erscheinungsdatum
2003
Sprache
Englisch
ISBN 10 
159059164X
ISBN 13 
9781590591642
Einband
Tapa blanda
Anzahl der Seiten
540
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar

Weitere beliebte Ausgaben desselben Titels

9781904347026: SQL SERVER QUERY OPTIM DISTILL

Vorgestellte Ausgabe

ISBN 10:  1904347029 ISBN 13:  9781904347026
Verlag: Wrox Press, Incorporated, 2003
Softcover