19 December 2010: Recent updates at www.sypron.nl
-------------------------------------------------


This month's quiz question would make a fine after-Christmas-dinner
discussion topic at the Secret Society of SQL Specia-
lists - but use at your own risk in less nerdy settings!
The basic question is whether ASE is right or wrong in a
particular way of handling a seemingly innocent order-by clause:
http://www.sypron.nl/quiz


I've been venturing into Sybase IQ for a while now, and I've made
available two stored procedures which I find handy to use. One of
these is ASE's sp_autoformat, ported to IQ. The other is an
improved version of sp_iqautoformat:
http://www.sypron.nl/iqprocs




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


My books on ASE and Replication server remain a popular resource
for DBAs from Bahrain to Bermuda, and from Cyprus to Chili, and in
fact pretty much anywhere else.
Check out the contents at the locations below, 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

HTH,

Rob V.
-----------------------------------------------------------------
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
-----------------------------------------------------------------