Recent changes to web pages of Rob Verschoor/Sypron B.V.

Recent changes to web pages of Rob Verschoor/Sypron B.V.

Post by Rob Verschoo » Sun, 24 Dec 2000 21:25:26



22-Dec-2000: Recent changes to web pages of Rob Verschoor/Sypron B.V.

Added tips and tools for quickly repairing identity gaps using the
undocumented command dbcc object_atts.
By itself, this command is next to unuseable; by wrapping a stored
procedure sp_identity around it, suddenly things are quick and easy.
    http://www.sypron.nl/idfix.html

Created a better overview of the various issues related to identity
columns
    http://www.sypron.nl/idgaps.html

Various corrections to the ASE QuickRef Supplement:
- added sp_dbcc_deletehistory and sp_dbcc_deletedb
- added some info and corrected minor errors in the sp_dbcc_* procs &
dbccdb setup section
- some corrections in dbcc log
- added info to lock section on lock timeout behaviour
- traceflag 260 was erraneously mentioned to suppress done-in-proc
packets; but this must be traceflag 292. (260 appears to apply to
version 10, but has since been replaced by 292).
    http://www.sypron.nl/ase_qref.html

Merry Christmas !
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11


WWW  http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

 
 
 

1. Recent changes to web pages of Rob Verschoor / Sypron B.V.

26 March 2001: Recent changes at www.sypron.nl
----------------------------------------------

"The Complete Sybase ASE Quick Reference Guide" has been
received with enthousiasm: folks around the world, from
Alaska to Hong Kong and from Barbados to Australia,
have already ordered the book (go to www.sypron.nl/qr
to order online).
In the mean time, some typos that have been discovered
in the book are listed on:
    http://www.sypron.nl/qr/errata.html

Downloadable System Table Posters for ASE & RepServer:
added links to the locations where these can be downloaded as
PDF documents
    http://www.sypron.nl/syblinks.html

Sybase certification: Brainbench test exams are not free anymore:
they now cost $19.95. Updated the document.
    http://www.sypron.nl/certtips.html#brain

----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0/11.5/11.0

Author of "The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/qr


WWW  http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

2. pgsql-server/src/backend/storage/buffer localbuf.c

3. unique index

4. Ingres, Linux, ODBC

5. Recent changes to web pages of Rob Verschoor/Sypron B.V.

6. Problems Connecting to SQL7 Server from SQL2000

7. Recent Changes to web pages of Rob Verschoor / Sypron B.V.

8. Recent changes to web pages of Rob Verschoor / Sypron B.V.

9. Recent updates to web pages of Rob Verschoor / Sypron B.V.