www.sypron.nl
Sybase Tips & Tricks
by Rob Verschoor
Search this site
Sybase Books by Rob V.
ASE QuickRef Guide (5
th
ed.)
RepServer QuickRef (2
nd
ed.)
IQ QuickRef Guide (1
st
ed.)
Tips, Tricks & Recipes (2
nd
ed.)
Buy these books now!
Quick Intro to ASE
What is Sybase ASE ?
Free copies of ASE
&
Linux
Finding ASE docs
Getting help with ASE
Sybase-related WWW links
Recommended books
So... you wanna be a DBA?
Tips & Tricks
Sproc results in a table
User-defined SQL functions
Identity gaps
CIS & XP tricks
Granting SA-commands to non-SA users
Tricks with 'sqsh'
Simulating dynamic SQL(1)
Simulating dynamic SQL(2)
Background Docs
MDA tables
ddlgen
Info on #temp tables
Login triggers
Avoid ASE perf. problems
Sybase IQ
What is Sybase IQ ?
Handy stored procs for IQ
Using IQ functions in ASE
IQ-to-ASE ODBC connections
Replication Server
RepServer tips & tricks
ASE Tools
sybinit4ever
sp_exec_table
sp_recreate
SQL-to-XML
Identity gap repair
dbccdb fault info
ASE/RS errorlog checker
"New Generation" sp_ procs
Blank passwords
Workload capture with Auditing
Miscellaneous
ASE quiz
SQL Poetry
Fun stuff
Sybase certification tips
DBA interview questions
Presentations etc.
Miscellaneous tools
Blogs:
sybase.com
,
sap.com
Old Stuff
sp_license
Query filter
New features in 12.5.0.1
ASE Replicator
ASIQ QuickRef(free)
RepServer QuickRef(free)
Hist. Server QuickRef(free)
ASE QuickRef Supplement(free)
Mailing List
Read our privacy guarantee
About this site
Who is Rob Verschoor?
What is Sypron B.V.?
2001 ISUG Award
CV/Resume
Customers
Certifications
Consulting
Info for Recruiters
Support this site!
Site Map
Shop
Quiz
Mailing List
Feedback
About this site
Copyright/Legal
Last updated: 18 December 2011
Downloadable files at
www.sypron.nl
My presentations at various Techwave conferences:
Techwave 2011 'Tips & Tricks' presentation
Techwave 2010 'Tips & Tricks' presentation (includes explanation of the 'automatic temptable statistics' feature)
Techwave 2008 'Tips & Tricks' presentation
Techwave 2007 (mostly about new features in ASE 15.0.2)
Also check out the
recorded sessions from Techwave 2007
.
Techwave 2006 ('Assorted Tips & Tricks; ASE 12.5 & ASE 15')
Techwave 2005 ('Assorted Tips & Tricks; ASE 15')
Techwave 2004 ('MDA tables, with Peter Dorfman')
Techwave 2003 ('MDA table basics')
Techwave 2002 ('Tips, Tricks & Misconceptions')
Techwave 2000 ('Assorted DBA tricks')
Techwave 1999 (' "New Generation" stored procs')
European ISUG conference 1998 ('Try this at home')
Additional material can be found
here
.
This document is located at
www.sypron.nl/downloads.html
Site Map
Shop
Quiz
Mailing List
Feedback
About this site
Copyright/Legal
Copyright © 1998-2012 Rob Verschoor/Sypron B.V.
"Solving Your Problems Now !"
All rights reserved. All trademarks are acknowledged.