Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
SQL Performance Tuning

Buy
SQL Performance Tuning, 9780201791693 (0201791692), Addison Wesley, 2002

SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms.

Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimization—and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations.

Topics covered include:

  • General and specific tuning

  • General sort considerations and options

  • Joins and subqueries

  • Columns and tables

  • Indexes, including B-trees and bitmaps

  • Constraints and stored procedures

  • ODBC and JDBC

  • Data changes and concurrency control (locking)

  • Clients, servers, and middleware

Whether you are a programmer, consultant, or user, you will find SQL Performance Tuning an indispensable guide to optimizing SQL performance across today's popular database environments.

Throughout SQL Performance Tuning, ideas and techniques are tested on a variety of popular SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical examples are written in ANSI/ISO Standard SQL: 1999.

(HTML tags aren't allowed.)

Neural Networks Theory
Neural Networks Theory
"Neural Networks Theory is a major contribution to the neural networks literature. It is a treasure trove that should be mined by the thousands of researchers and practitioners worldwide who have not previously had access to the fruits of Soviet and Russian neural network research. Dr. Galushkin is to be congratulated and thanked for his...
Fundamentals of Data Visualization: A Primer on Making Informative and Compelling Figures
Fundamentals of Data Visualization: A Primer on Making Informative and Compelling Figures

Effective visualization is the best way to communicate information from the increasingly large and complex datasets in the natural and social sciences. But with the increasing power of visualization software today, scientists, engineers, and business analysts often have to navigate a bewildering array of visualization...

Advanced Data Mining Techniques
Advanced Data Mining Techniques
This book covers the fundamental concepts of data mining, to demonstrate the potential of gathering large sets of data, and analyzing these data sets to gain useful business understanding. The book is organized in three parts. Part I introduces concepts. Part II describes and demonstrates basic data mining algorithms. It also contains chapters on a...

Adoption and Adaption in Digital Business
Adoption and Adaption in Digital Business
We live with change. The losing sports team makes changes to become a winning team through the consistent and persistent application of proven principles applied pragmatically. The sports team trains differently, skills up, varies the plays and nurtures the players, brings new leadership, and takes time to resolve issues. The winning team comes...
Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)
Professional Excel Development : The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R)

Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications.

This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge...

Graph Theory (Graduate Texts in Mathematics)
Graph Theory (Graduate Texts in Mathematics)
and guided mainly by the Four-Colour Conjecture. The resolution of the conjecture by K. Appel and W. Haken in 1976, the year in which our first book Graph Theory with Applications appeared, marked a turning point in its history. Since then, the subject has experienced explosive growth, due in large measure to its role as an essential structure...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy