28 November 2010: Recent updates at www.sypron.nl

This month's quiz question is about saving lots of keystrokes
for some commonly used commands ...

I've also updated the answer to last month's quiz question based
on reader feedback

The stored proc sp_mda_monOpenObjectActivity has been enhanced
to report each table's size and rowcount. Also provided a
version for users of ASE 12.5.

The collection of useful SQL UDFs has been extended with 'sp_range()',
a function provided by Robert Munson. This can be used in 'group by'
and 'order by' to get a statistical distribution of unknown data (see
the comments in the SQL UDF code for more info and examples).

Added a link to Nicolas Gouteux' SQL Browser tool.

Follow me on Twitter: http://twitter.com/rob_verschoor

My books on ASE and Replication server keep finding their way to DBAs
across the world.
Preview the books, and order your own 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"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666