24 May 2010: Recent updates at www.sypron.nl

This month's quiz question is about a strange problem
I had last week with long identifier names in ASE 15.x...

I've added some additional information to the
answer to the question from April, about ways of
making a query run slower:

I finally managed to post the solution to my exercise-for-the-reader
from my 2009 ISUG Journal article on 'missing statistics':

Added a stored procedure to calculate delta values for the MDA table
monOpenObjectActivity in a really simple way (this replaces a pretty complex
piece of exmaple SQL that I listed before)

In the mean time, my other books on ASE and Replication server are still
going strong and finding their way across the globe to the desks of DBAs.
Preview the books, and order your copy, at www.sypron.nl/shop:

- The recently released 5th edition of the well-known 'purple book' "The
Complete Sybase ASE Quick Reference Guide" is updated for ASE 15.0.3
and ASE Cluster Edition.

- The 2nd edition of "Tips, Tricks & Recipes for Sybase ASE" has
been updated for ASE 15.0 and is a must-have when you're upgrading
to ASE 15:

- The 2nd edition of the 'green book' -- "The Complete
Sybase Replication Server Quick Reference Guide", updated
for RepServer 15.0 and 15.1:

Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666