Last updated: 03 September 2006
Tips, Tricks & Recipes for Sybase ASE
2nd edition (updated for ASE 15.0)

About the second edition:
  • Fully reviewed and updated for ASE 15.0
  • New chapter about ASE 15.0 query processing tricks
  • 80 pages of new material in the 2nd 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)
  • 500 pages; 17*23 cm (6.5*9"); lay-flat binding
  • Used by ASE DBAs in more than 60 countries around the world
  • Written by Rob Verschoor, Certified DBA for ASE 12.5/12.0
  • ISBN 978-90-806117-2-6 (90-806117-2-7)
Tips, Tricks & Recipes for Sybase ASE; click to enlarge

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.

The table of contents can be found here (2ndedition; PDF format; ~225 Kb)

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 timestamp column;
  • 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.

Where to buy ?
"Tips, Tricks & Recipes for Sybase ASE" is available from (using secure credit card payment). Orders from most countries accepted.
Information on price, discounts, shipping and distributors is here.

Reviews & comments
A review of this book (from the ISUG Technical Journal) is here (PDF). Another review (from the PowerBuilder Developer's Journal) is here.
Below are some comments from readers about "Tips, Tricks & Recipes for Sybase ASE".
To see how Sybase CEO John Chen likes this book, go here.

"If you're watching over Sybase ASE servers, this book is a keeper! It provides practical insight and expertise to DBAs of any skill level while challenging your understanding of several topics. I know you'll learn something new and useful ... I did!"

Peter Thawley
San Francisco Bay Area, CA (USA)

"I have been reading your book 'Tips, Tricks & Recipes...' for three days without pause (only for sleeping) and found it to be very interesting and useful.
Although official Sybase manuals are excellent, your book is one 'wonderful patch installed on top of ASE official manuals' covering many holes and misunderstandings in them. It is worth of every cent spent to it."

Niksa Jurinovic
Ottobrunn (Germany)

"I really like your "tips & tricks" book. I've been using Sybase for a long time now (since 4.2) but I've learned a lot from your book. Many thanks."

Jill Goodman
Washington, DC (USA)

"I can safely say this [book] is one of the best investments I've ever made in terms of technical book purchases. Congratulations, because this is going to be an essential tool and a classic in the sybworld."

Jeff Larson
Chicago, IL (USA)

"This particular work by Rob complements the recent "The Complete Sybase ASE Quick Reference Guide" quite nicely. It is a concise masterpiece that brings together all 'syb-functionality' under one-roof. The amount of analysis per command is staggering as the work not only shows you 'best practice' methods but also the justification behind it. There are so many ways to manage your ASE server and it is outlined VERY WELL in this work. In my opinion this will become the ASE-HOLY GRAIL."

Shaheed Davids
Investec Bank, Treasury
Johannesburg (South Africa)

"This book is great for suggestions, tips and tricks and background info and not only *usable* but also *readable* like a (good) novel.
It is an invaluable aid in knowing what you are doing and what the implications are for your environment.
Keep this book next to Rob's 'ASE Quick Reference Guide'. The ASE Quick Reference Guide is really great for being very concise, but due to it's nature, it does not come with too much background info."

Ron Smit
Naaldwijk (The Netherlands)

"This is one of those books that won't gather dust on your bookshelf. After 'The Complete Sybase ASE Quick Reference Guide', this is one of most practical books I ever used. Thanks Rob, for a book like that."

Rainer Schlichter (freelance DBA)
Munich (Germany)

"Your book is tremendously useful, and not just for Sybase. I also have some [Microsoft] SQL Servers, and I've already used some of your tips and tricks there too. I warmly recommend this book to ASE DBAs and SQL Server DBAs alike."

Vijay Singh
New York City, NY (USA)

(Please note that the above statements represent the opinions of these individual DBAs, and not of their employers)

 This document is located at