Hi: I am working on performance tuning a two-tier Java Swing application which connnects to an Sybase ASA database (version 10.0.1). We are currently doing a profiling of the a …

When your Database contains a EVENT of type DatabaseStart and you are able to crash the Database Engine during startup with your fabulous code. How would you fix the database to …

If this sample was helpful to you, vote it up. If you have an improved version, or a closely related sample, post it as an answer. If you have a question or complaint, post it as …

Since we upgraded our Database from 9.0.2. to 10.0.1. one of my trigger constructs is broken. When a user changes a value in a purchase order line (testchild) the purchase order ( …

I try to use this function on SQLA 10.0.1.3976 as a test. alter FUNCTION "DBA"."UNBlacklist"() returns long varchar url 'http://www.un.org/sc/committees/1267/consolidatedlist.x …

When i execute the following command I'm a little bit surprised of the result. select -12345678901234.0001 as TestVal, str( TestVal, 40, 2) as stringVal union all select -123456 …

Given the following SQL Script I try to produce a Result set looking like this Lable Value ------------------------ UstId_1 DE123456789 ErrorCode 200 BEGIN decl …

We have multiple clients that are in, what we call, a three-tiered replicating environment. This means we have a Main Site that has Remote Sites. Once those Remote Sites are load …

I have some table : create table people ( id bigint not null default autoincrement, first_name varchar(50) not null, last_name varc …

How is performance impacted when you have a table that, lets say could have over 1M rows, and there are 3-5 columns that are consistently NULL. Is it bad design to have data struc …

I see heated discussion all over the internet about whether a GUID is a poor choice for a primary key. Usually, these conversations all revolve around SQL Server. A lot of people …

If I had a table defined like below, how, from my application would I be able to get the next value for the "id" column before saving any data to the database? create table people …

I need to download UN Blacklist XML file periodically. Is there any way to automate this using sql ONLY?

We have an application that uses a last_update (timestamp) column on just about every table. We manage this column on the client side, but due to differences in user clocks (alway …

Is there one available somewhere for SQL Anywhere like there is for ASE? (v10.0.1)