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 ...
http://www.sypron.nl/quiz


I've also updated the answer to last month's quiz question based
on reader feedback
http://www.sypron.nl/quiz2010a.html#oct10upd


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.
http://www.sypron.nl/mda


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).
http://www.sypron.nl/udf


Added a link to Nicolas Gouteux' SQL Browser tool.
http://www.sypron.nl/syblinks.html#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.
http://www.sypron.nl/qr

- 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:
http://www.sypron.nl/ttr

- The 2nd edition of the 'green book' -- "The Complete
Sybase Replication Server Quick Reference Guide", updated
for RepServer 15.0 and 15.1:
http://www.sypron.nl/repqr

-----------------------------------------------------------------
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
-----------------------------------------------------------------