SQL Performance Tuning

Book Details:

Publisher:	Addison-Wesley Professional
Series:	Addison Wesley , Performance
Author:	Peter Gulutzan
Edition:	1
ISBN-10:	0201791692
ISBN-13:	9780201791693

Pages:	528
Published:	Sep 20 2002
Posted:	Nov 19 2014
Language:	English
Book format:	CHM
Book size:	1.4 MB

Book Description:

A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBA's and programmers improve the performance of their databases. It is not an introduction to SQL, nor is it a tuning manual for a particular SQL implementation. It is a guide for users and programmers who want to improve SQL performance no matter what brand of SQL they use. It will provide tuning tips for common situations, such as how to change a query so it will go faster and how to shift work from the server to the client. All the ideas have been tested against the eight leading DBMS applications. Almost all large organizations and companies today run more than one type of database. This is the only book to cover database tuning for them.

Download Link:

Related Books:

SQL Server 2012 Query Performance Tuning

3rd Edition

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritcheys book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. It provides the tools you need to approach your queries with performance in mind. SQL Server 2012 Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. Youll learn to be proactive in establishing performance baselines using tools like Perfo...

Oracle High Performance Tuning

For 9i and 10g

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside inde...

Java Performance Tuning

2nd Edition

Performance has been an important issue for Java developers ever since the first version hit the streets. Over the years, Java performance has improved dramatically, but tuning is essential to get the best results, especially for J2EE applications. You can never have code that runs too fast.Java Peformance Tuning, 2nd edition provides a comprehensive and indispensable guide to eliminating all types of performance problems. Using many real-life examples to work through the tuning process in detail, JPT shows how tricks such as minimizing object creation and replacing strings with arrays can really pay off in improving your code's performance.Tuning J2EE...