Sybase - Commands, SQLs, etc

• Search Sybase objects by its type

SELECT name FROM sysobjects
WHERE type='D'

'U' -- user

'S' -- system

'P' -- procedure

'V' -- view

'D' -- default

'TR' -- trigger

• Show details of a stored-procedure

sp_helptext 'sp_how_are_you'

• Get DB name

SELECT db_name()

• to continue

If You'll Die Today

Dream as if you'll live forever.
Live as if you'll die today.

Java Performance

$ jstack -l {pid}
$ kill -3 {pid}