SQL Server Query Performance Tuning
Distilled
Buch in deiner Nähe kaufen
Beschreibung
Curlingstone
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
A completely revised edition of a book that is highly-regarded in the community (as evidenced by Amazon reviews and other customer feedback) The only comprehensive, practical guide to performance optimization techniques for SQL Server applications Essential reading for any DBA or developer resposible for the performance of an exisiting SQL Server system, or the design of a new one
Autor*in
Sajal Dam