Sybase
Dossier
Sybase a longtemps été considéré plus performant qu’Oracle mais depuis quelques années, principalement pour des questions de licence, cette base de données est de moins en moins utilisée comme référentiel d’ordonnancement.
Référentiel
Tous les ordonnanceurs nécessitent un référentiel pour stocker les données, certains éditeurs utilisent leurs propres bases mais d’autres préfèrent s’appuyer sur des produits du marché.
A voir sur le net
- Livres Sybase
- Linux campaign (promo-offer) - Sybase Inc
- comp.databases.sybase Google Group
Implementations of the SQL Server.
- Sybase - Wikipédia
Article Wikipedia.
Accès rapide
Recent updates at www.sypron.nl
14 March 2010: Recent updates at [link] ------------------------------ ---------------- This month's quiz question is about a head-against-the-wall problem that took an evening to solve last week... [link] Vishi R supplied a new version (...)
15 mars 2010
source : comp.databases.sybase Google Group
Sybase treats unique key violation diffeerently for individual vs group updates
Let's put a primary key on the table_name for columns (key_field, key_field2) THIS WILL WORK: begin tran update table_name set key_field = key_field + 1 where key_field2 = some_value rollback tran go ------------------------------ (...)
3 mars 2010
source : comp.databases.sybase Google Group
Whitepaper on Location Intelligence
The Yellowfin BI team have produced a new paper on "Location Intelligence", the mashup of BI with GIS Extract More than 70% of your organizational data has a location component - be it a customer address or a sales territory. This combined (...)
3 mars 2010
source : comp.databases.sybase Google Group
Looking for a method to find a crashing transaction in the stable queue?
When I dump the queue using "sysadmin dump_queue" I see a ton of transactions wrapped in begin tran/commit that have nothing to do with the error message. I take the batching off via 'alter connection set batch to 'off' to make (...)
2 mars 2010
source : comp.databases.sybase Google Group
how is this possible (duplicate entries)?
I'm replicating the entire database, and refresh the replica using dump marker method. After I load the replica and resume connection, all of a sudden I get a flurry of duplicate inserts into quite a few tables. How is this possible? (...)
27 février 2010
source : comp.databases.sybase Google Group
