Troubleshooting SQL

Features

• Cover Type: Paperback with 384 pages
• Published by: McGraw-Hill Companies September 14, 2001
• Written in: English
• ISBN 10 Number: 0072134895
• ISBN 13 Number: 978-0072134896
• Book Dimensions: 9.2 x 7.4 x 1 inches
• Weighs: 1.7 pounds

Product Description
This programmer's resource explains how to optimize SQL statements and procedures and create a customized SQL debugging environment for error-free applications. You'll get programming tips, best practices, plus coverage of Oracle SQL and PL/SQL and T-SQL for SQL Server.

Back Cover Copy


The Ultimate Resource for Developing Error-Free SQL Operations

Create a functional debugging environment to develop Structured Query Language solutions efficiently and troubleshoot SQL statements effectively. Use best practices to help perform maintenance, and to find and fix bugs when they do occur. Explore and familiarize yourself with SQL programming problems, learn to write code that's portable across databases, and realize efficiencies by expressing data in a variety of types. Develop the skills you need to debug SQL, and learn to move deftly and creatively around almost every limitation that SQL imposes on your operating environment. Write trouble-free SQL statements and procedures Optimize SQL statements and avoid problem areas Join and aggregate data and other SQL Select statements Debug and use practical regions and sequences Use and debug arrays, sets, and graphs Understand tree structures and hierarchies Secure data and protect response time Examine the appropriate use of data types Select, insert, update, and delete data using SQL syntax Recognize and mitigate fatal and logical errors Format SQL for single queries or extensive procedures using best practices

Reader Reviews
This book is not as advertised. The blurb on Amazon says: "You'll get programming tips, best practices, plus coverage of Oracle SQL and PL/SQL and T-SQL for SQL Server." This book is a collection of introductory material on SQL and RDBMS's, with about 99% of the information and examples exclusively based on SQL Server. With very few exceptions, even the few things this author has to say about Oracle in this book are completely wrong. The most outrageous point I found was a simplistic explanation of transactions in Oracle as consisting of commit and rollback in SQL*Plus. In the more detailed section on SQL Server that follows it we find this little gem of a quote: "Unlike in SQL*Plus, the ROLLBACK command iin Transact-SQL can also be used to revert to the last savepoint." Clearly the author does not have a clue how transactions and savepoints work in Oracle, which gives the developer or DBA an extraordinary array of control mechanisms for transactions, both programmatic and interactive. If you want an introduction to SQL Server by someone with a few tired tips on Microsoft datatypes and a lot of oft-repeated generalities, this is the book for you. If you are looking for a serious book on troubleshooting Oracle SQL, get Harrison's Oracle SQL High-Performance Tuning and Tom Kyte's new book. If you're looking for how to tune SQL on Sybase/SQL Server, I'm not the one to ask, since I tune Oracle databases for a living.