Sybase ADDICT

To know when the last full backup of your database occurred you can look at the backupserver logfile, of course. But you don’t have to. Indeed you can find this information with Sybase ASE using the command “dbcc dbtable”.
Read more…

To list the tables that use datapages or datarows locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and (sysstat2 & 16384 = 16384 or sysstat2 & 32768 =32768)

To list tables that use allpages locking scheme, use:

select name,sysstat2
from sysobjects
where type = 'U'
and sysstat2 & 8192 = 8192

A database administrator regularly need to address database performance issues. But database performance and tuning is not always an easy task because it can sometimes involve several complicated processes to find bottlenecks. For several years now, I use a free tool  named ASEMON released under GNU GPL license (yes, it is open source !!). ASEMON is developed and maintained by Jean-Paul Martin at Sybase France. Here is a short description of the product…

1°) What is ASEMON ?

ASEMON is an efficient and reliable tool that collect and store performance metrics from various Sybase products such as Sybase ASE, Replication Server and Sybase IQ. It is made of two components:

Read more…

Embarcadero software and ISUG (International Sybase User Group) offer a free online webinar about query optimization for Sybase ASE. In this particular webinar, you will be able to ask directly your questions to optimize your sql queries with a bunch of top Sybase ASE experts like Peter Dobler and Kevin Sherlock. Query performances, Sybase ASE optimizer and optimizer mode will be discuss. This webinar is a valuable way to acquire or expand your knowledge.

3 sessions of this free webinar are scheduled October 21th from 7:00AM to 7:00PM.
See the schedule here.

Wonder how to display or delete duplicate records ? Sometimes, under certain circumstances duplicate data may occur. Then it should be deleted.

In this example, we are going to create a dummy table with an identity column as a unique key, and with two varchar columns. Then we are going to insert data and duplicates manually. The script for the test comes as follow:

create table dummytable(
keycolumn   numeric(5,0) identity,
column1     varchar(10),
column2     varchar(10)
)
go

insert dummytable(column1,column2) values("AAA","AAA")
go 10
(1 row affected)
10 xacts:

insert dummytable(column1,column2) values("AAA","BBB")
go
(1 row affected)

insert dummytable(column1,column2) values("BBB","BBB")
go
(1 row affected)

insert dummytable(column1,column2) values("BBB","AAA")
go
(1 row affected)

Read more…