SQL Performance Tuning

Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database. Not a list of one-off tr

Proven PL/SQL optimization solutions from Oracle Press Oracle PL/SQL Performance Tuning Tips & Techniques presents a hands-on approach to enabling better, faster, and safer results from PL/SQL. Th

Offers tips for improving the performance of any SQL database, no matter what the platform. Written for experienced database administrators familiar with SQL, the book identifies the similarities and

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's bookSQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance proble

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 per

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or

Field-tested techniques for optimizing SQL Server 2014 databases and applications for speed and performanceMicrosoft SQL Server 2014 Query Tuning & Optimization reveals how to get peak performance

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next

"System Performance Tuning" covers two distinct areas: performance tuning, or the art of increasing performance for a specific application, and capacity planning, or deciding what hardware best fulfil

In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Gurry's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracl

SQL tuning improvements existing execution plans. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution

Expert Oracle RAC Performance Diagnostics and Tuning provides comprehensive coverage of the features, technology and principles for testing and tuning RAC databases. The book takes a deep look at opti

Packed with practical examples, this book looks at a different aspect of performance tuning in each chapter and shows you how to apply them to their existing Java applications. Anyone with an interest

With contributions from some of the most notable experts in the field, Performance Tuning of Scientific Applications presents current research in performance analysis. The book focuses on the followin

Use this fast and complete guide to optimize the performance of MongoDB databases and the applications that depend on them. You will be able to turbo-charge the performance of your MongoDB applications to provide a better experience for your users, reduce your running costs, and avoid application growing pains. MongoDB is the world's most popular document database and the foundation for thousands of mission-critical applications. This book helps you get the best possible performance from MongoDB.MongoDB Performance Tuning takes a methodical and comprehensive approach to performance tuning that begins with application and schema design and goes on to cover optimization of code at all levels of an application. The book also explains how to configure MongoDB hardware and cluster configuration for optimal performance. The systematic approach in the book helps you treat the true causes performance issues and get the best return on your tuning investment. Even when you're under pressure and

As with previous versions of this Oracle Press bestseller, Oracle Database 11g Performance Tuning Tips & Techniques provides instructions that explain the best ways of maintaining a high-performance O

Modern multicore processors offer immense opportunities to improve Java performance, but they also make Java performance tuning more complex than ever. Java Performance Companion helps you systematica

The only Oracle Press guide to JD Edwards EnterpriseOne performance tuning, covering the latest release Real-world examples show how system administrators can get radically improved performance from e

SQL Server 2014 follows just in 2 years after SQL Server 2012 with very exciting new features. One on the top: in-memory OLTP tables for superior performance. With abundant computer memory, why keep t

Discover how to maintain and update balanced scorecards and performance dashboards with SQL Server Reporting ServicesComplementing the bestselling Balanced Scorecards and Operational Dashboards with M

Automatic Performance Tuning is a new software paradigm which enables software to be high performance in any computing environment. Its methodologies have been developed over the past decade, and it i

Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the b

A handbook covering PL/SQL provides a wide range of tips and techniques for insuring coding style consistency and coding approaches for the best performance of PL/SQL programs and furnishes informatio

Currently, no books exist that focus on the practicalities of Java application performance tuning, as opposed to the theory and internals of Java virtual machines. This practical guide is the "missing

Master Oracle E-Business Suite 12 Performance Tuning and Optimization Deliver on the promise of lower TCO and achieve operational excellence by implementing a comprehensive enterprise application mana

Turn your daily driver, weekend fun ride, or track car into a corner-carving performance machine.?From planning a course of modifications to installing parts to tuning handling characteristics, High-P

Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Mi

An indispensable guide for any Oracle professional looking for tuning techniques, this reference for database administrators features techniques for monitoring and optimizing memory storage. Focusing

According to industry studies, 70-80% of database performance problems are caused by poorly written code. Microsoft® Transact-SQL® The Definitive Guide is a comprehensive T-SQL languag

As tools for tuning modern engines have become more powerful and sophisticated in recent years, the need for in-depth knowledge of engine management systems and tuning techniques has grown. Tuning eng

Database professionals will find that this new edition aids in mastering the latest version of Microsoft’s SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in applica

With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing t

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the

Professional Spark addresses the challenges in moving from proof-of-concept or demo Spark applications to live Spark in production. It covers:Cluster Managers Performance Tuning Security Lifecycle of

The development of an athlete from basic performance to elite level of accomplishment is a long and complicated process. Identifying and nurturing talent, developing and fine tuning sport skills, and

The development of an athlete from basic performance to elite level of accomplishment is a long and complicated process. Identifying and nurturing talent, developing and fine tuning sport skills, and

In this work, the unique power measurement capabilities of the Cray XT architecture were exploited to gain an understanding of power and energy use, and the effects of tuning both CPU and network band

All performers know that "tuning up the body" is necessary to maximize performance. A person's mannerisms, habitual patterns of movement, and posture can block the capacity for expression, often witho

Following in the tracks of the author’s well-known Alfa DOHC tuning manual, Jim Kartalamakis describes all kinds of useful information and techniques to increase power, performance and relia