Recent updates at www.sypron.nl #81

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

0
Rob
12/20/2010 2:11:45 AM
sybase.ase.general 8655 articles. 0 followers. Follow

0 Replies
571 Views

Similar Articles

[PageSpeed] 59

Reply:

Similar Artilces:

Recent updates at www.sypron.nl: updated RepServer QuickRef guide
24 June 2001: Recent updates at www.sypron.nl --------------------------------------------- Check out some comments by DBAs who bought "The Complete Sybase ASE Quick Reference Guide" at www.sypron.nl/qr/index.html#dbaquotes The book can still be ordered online at www.sypron.nl/qr. A new ASE Quiz question about the "raiserror" command. Are you sure you know everything about it ... ? http://www.sypron.nl/quiz.html Finally, I managed to updated the Replication Server QuickRef Guide for RS 12.0. It has also been corrected and improved in many places, an...

Recent updates at www.sypron.nl
02 June 2002: Recent updates at www.sypron.nl --------------------------------------------- This month's ASE quiz question features a math problem. Test your combined math/SQL skills at http://www.sypron.nl/quiz.html A new certification exam for ASE 12.5 was released in May 2002. Some info about this exam was added to http://www.sypron.nl/certtips.html Grant Queenin kindly suggested some improvements to the SQL-to-XML tool which was added last month. The latest version is at http://www.sypron.nl/xml.html Some further troubleshooting tips about ASE Repl...

Recent updates at www.sypron.nl
28 June 2008: Recent updates at www.sypron.nl --------------------------------------------- The second edition of "The Complete Sybase Replication Server Quick Reference Guide" (also known as the 'green book') is now in sight. I've received many questions when this would be available, but I had to wait for RepServer version 15.1 to be released by Sybase since I wanted to cover the latest available versions. As 15.1 finally came out last week (later than originally expected), I'm expecting the second edition to be available around mid-July -- stay tuned. I...

Recent updates at www.sypron.nl
01 February 2003: Recent updates at www.sypron.nl ------------------------------------------------ This month's ASE quiz question is about a really simple piece of T-SQL code I wrote recently... and took much longer than it should have... http://www.sypron.nl/quiz.html The stored procedure 'sp_restart_server' has been revitalised. It will now work with 'sqsh', run on Linux-based ASE, and also works for ASE 12.0 and later. On NT, the scheduling has been improved. In case you're wondering: 'sp_restart_server' stops, and automatically...

Recent updates at www.sypron.nl
20 May 2001: Recent updates at www.sypron.nl -------------------------------------------- "The Complete Sybase ASE Quick Reference Guide" has already been ordered by many DBAs all around the world. The book can still be ordered online at www.sypron.nl/qr. A new ASE Quiz question: when transferring a table with a simple BCP-out/BCP-in, is it guaranteed that the data will always remain unchanged ? Check out the below link, especially if you'd answer "yes" to this question... http://www.sypron.nl/quiz.html Updated "sybinit4ever" for ASE 12...

Recent updates at www.sypron.nl #41
22 July 2005: Recent updates at www.sypron.nl --------------------------------------------- This month's quiz question is about the easiest way to find out the proper parameters for system stored procedures (like sp_addsegment)... http://www.sypron.nl/quiz Admittedly, last month's quiz question was a very technical and difficult one. If you haven't seen the answer yet, check it out here: http://www.sypron.nl/quiz2005a.html#jun05 My books about ASE and RepServer are still are still very popular with Sybase DBAs from Iceland to South Africa and fr...

Recent updates at www.sypron.nl #62
30 August 2008: Recent updates at www.sypron.nl ----------------------------------------------- This month's quiz question is about a recent virus performing a SQL injection attack, and how Sybase databases may be affected by this... http://www.sypron.nl/quiz The list of changes to the MDA tables has been updated to include 15.0.2 esd#5: http://www.sypron.nl/mda As you've probably noticed, the second edition of "The Complete Sybase Replication Server Quick Reference Guide" (also known as the 'green book') was finally released last mo...

Recent updates at www.sypron.nl #59
02 December 2007: Recent updates at www.sypron.nl ------------------------------------------------- This month's quiz question is about a common misunderstanding around the 'truncate table' statement: http://www.sypron.nl/quiz In response to questions I get asked frequently, about what it takes to become a DBA, I've created a new page with some answers as well as some suggestions to get started with ASE if you've never used it before: http://www.sypron.nl/dba.html If you're a DBA or developer for ASE or Replication Server, chec...

Recent updates at www.sypron.nl #40
20 June 2005: Recent updates at www.sypron.nl --------------------------------------------- In the past weeks, www.sypron.nl has moved to a new server at a new ISP. This was necessary to accomodate the growing volumes of traffic. As a result of this move, you may have experienced some downtime of parts of the site. Apologies for that -- it should all be working fine again now. This month's quiz question is about a deadlock problem that kept me busy for a while. For a change, the answer will be published in a few weeks so as to give you some time to ponder over this midsummer...

Recent updates at www.sypron.nl #61
28 June 2008: Recent updates at www.sypron.nl --------------------------------------------- The second edition of "The Complete Sybase Replication Server Quick Reference Guide" (also known as the 'green book') is now in sight. I've received many questions when this would be available, but I had to wait for RepServer version 15.1 to be released by Sybase since I wanted to cover the latest available versions. As 15.1 finally came out last week (later than originally expected), I'm expecting the second edition to be available around mid-July -- stay tuned. I...

Recent updates at www.sypron.nl #44
13-Nov-2005: Recent updates at www.sypron.nl -------------------------------------------- This month's quiz question has to do with timezones... http://www.sypron.nl/quiz The changes to the MDA tables in ASE 15.0 have been added at: http://www.sypron.nl/mda.html Added two new dbccdb faults in ASE 15 at: http://www.sypron.nl/faultinfo.html My books about ASE and RepServer are still popular among Sybase DBAs and developers in more than 60 countries around the world. Order your own copy online: - "The Complete Sybase Replication Server Q...

Recent updates at www.sypron.nl #58
21 October 2007: Recent updates at www.sypron.nl ------------------------------------------------ First, there have been some problems with the availability of www.sypron.nl in the past few weeks. This was caused by technical problems at our hosting provider, and has now been fixed. Sorry for that. This month's updates are: This month's quiz question is about a quick way to track the progress of a DML operation: http://www.sypron.nl/quiz The list of schema changes to the MDA tables has been updated to include 15.0.2: http://www.sypron.nl/mda A...

Recent updates at www.sypron.nl #27
05 January 2004 : Recent updates at www.sypron.nl ------------------------------------------------- The solution to last month's Christmas Quiz Question is now online. Full details, plus the names of the prize winners, are at http://www.sypron.nl/quiz2003b.html#dec03 This month's ASE Quiz Question is about a rather straightforward update statement... http://www.sypron.nl/quiz Two new stored procedures were added, allowing unpriviliged users to effectively run 'dbcc sqltext' and use the optimizer-related traceflags 302, 310 and 317. ...

Recent updates at www.sypron.nl #38
13 February 2005 : Recent updates at www.sypron.nl -------------------------------------------------- This month's quiz question is about Replication Server: how can you set up a warm standby while keeping latency as short as possible? http://www.sypron.nl/quiz Brainbench has a new test for ASE 12.5; unfortunately, it isn't very good. http://www.sypron.nl/certtips.html A page has been added with links to free copies of enterprise-grade Linux (that can be used with Linux versions of ASE). http://www.sypron.nl/get_linux.html As of 1 Febr...

Web resources about - Recent updates at www.sypron.nl #81 - sybase.ase.general

Windows Update - Wikipedia, the free encyclopedia
Windows Update is a service provided by Microsoft that provides updates for the Microsoft Windows operating system and its installed components, ...

Gizmodo.com Updates
Nobody should have to use a pay phone , natural disaster or no natural disaster. So if your gadgets are out of juice after Sandy, here’s a tiny ...

Lifehacker.com Updates
By Whitson Gordon Ever run into a situation where you have multiple wireless networks available, but one is clearly better than the other? WiFi ...

Facebook To Update Mobile Apps Every 4 To 8 Weeks
On the same day that Facebook released a bunch of mobile updates for Apple and Android devices , the social network also announced that it will ...

China Mobile (Hong Kong) Ltd. Analyst Ratings Update
China Mobile (Hong Kong) Ltd. Analyst Ratings Update American Trade Journal Research firm Zacks has rated China Mobile (Hong Kong) Ltd. (NYSE:CHL) ...

Windows 10 Mobile Update For Older Lumias Pushed To 2016
... the roll out of Windows 10 Mobile to existing Lumia devices in December. With December being half over by this point, the fact that the update ...

Microsoft updates OneDrive with Spotlight search and offline file support
Microsoft has recently pushed a couple of updates to the official iOS app of its cloud storage service , OneDrive , thereby introducing a couple ...

AVG update to fix false Trojan warning
... isn't there. Tony Mays, Europan PR Director at AVG Technologies, said: "Our virus-lab confirms it’s a false positive and from the next update ...

Market update, December 18 - Business Insider Deutschland
Stock futures are lower and crude oil is near the lowest levels since early 2009.

Polling update: The Trump surge continues, nothing new on the Democratic side
REPUBLICANS Once again, the interesting action this week has all been on the GOP side. I mean, Donald Trump had hovered around the 30 percent ...

Resources last updated: 12/19/2015 4:42:10 PM