Tips, Tricks & Recipes for Sybase ASE, 2/e (updated for ASE 15.0)

• Fully reviewed and updated for ASE 15.0
• New chapter about ASE 15.0 query processing tricks
• 80 pages of new material in the 2^nd edition (see the last page of the table of contents for more details)

• Useful tips for ASE DBAs and developers
• Describes many ASE tricks that have never been published before
• Includes selected ASE internals
• Ready-to-use tools and examples
• All code samples are available electronically (see appendix D in the book)

Scope & Contents
"Tips, Tricks & Recipes for Sybase ASE" describes many perhaps-not-so-obvious ways of using ASE features to increase the usefulness and productivity of ASE. Many of these tips & tricks have not been published or presented before.
This book provides a wealth of practically useful information for all DBAs and developers working with Sybase ASE. It includes suggestions and workarounds to help reduce downtime and improve productivity and performance. For various topics, an explanation of related ASE internals is included.

For example...
Here are just a few examples of the sort of thing described in "Tips, Tricks & Recipes for Sybase ASE" :

• How to determine the clock time corresponding to a particular value in a timestampcolumn;

• How to avoid that a shutdown with nowait leads to identity gaps, even in pre-12.0 (and without using the two-table design technique I've described before).

• How to dynamically toggle the ignore_dup_key option for an index;

• How an ANSI outer join can implement some functionality much more efficiently than a classic T-SQL outer join;

• How to test for the existence of a specific global variable or a built-in function from T-SQL;

• How to perform a shutdown with nowait without knowing the sa password;

• And much, much more...

About the author
This book is written by Rob Verschoor, Certified DBA for ASE 12.5/12.0, and author of the successful ASE book "The Complete Sybase ASE Quick Reference Guide" (please note that "Tips, Tricks & Recipes for Sybase ASE" is not a quick reference guide, but a full-size book).
Those who are familiar with Rob's work will know what to expect: thought-provoking, out-of-the-box thinking and innovative applications of ASE features, but always geared towards practical usefulness.

What makes this book different?
Unlike many other books about ASE, "Tips, Tricks & Recipes for Sybase ASE" does not just discuss existing ASE functionality. Instead, this book goes one step further and explores new dimensions of ASE features.
From seasoned DBAs to experienced developers, this book will be a source of inspiration for everyone working with Sybase ASE.