
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance–related problem areas.
This book offers a practical, hands-on approach to diagnosing and resolving performance issues in SQL Server 2008. It focuses on identifying poorly performing stored procedures and queries, pinpointing the root causes of these problems, and implementing effective solutions. The methodology presented is direct and troubleshooting-oriented, aiming to provide readers with techniques they can immediately apply to their daily work.
The book is designed to be a practical guide for SQL Server developers and administrators, focusing on immediate application of troubleshooting techniques. Its emphasis on direct problem-solving and avoidance of deep theory suggests it aims to be a go-to resource for common performance issues. The structure, dedicating chapters to specific problem areas, indicates a systematic approach to addressing query tuning. The content is tailored for SQL Server 2008, highlighting specific features and optimizations relevant to that version.
Page Count:
628
Publication Date:
2009-03-16
Publisher:
Apress
ISBN-10:
1430219025
ISBN-13:
9781430219026
No comments yet. Be the first to share your thoughts!