I can't drop a table in Sybase ASE 15. I launch a drop table SORTING_PLAN_SOURCE command in SQuirreL SQL, and it just goes on and on, without answering. After a while (like 5 minutes), I cancel the ...
I support a database that has many tables that hold very similar data. Over time, much of this data isn't needed, and the table names are dynamic as an application is creating these tables, and the ...
There is a poorly written stored proc in an older Sybase 12.5 database that I need to make faster, but I can't change the code. I can change the database settings, indexes, engines, OS settings, etc. ...
I have a DB with mixed data & log segments. I also have some log on data device & the other way too.. The target is to have the data & log segments aligned properly , please guide me how ...
I need to know about backup & recovery strategies for partitioned Database in Sybase ASE 15.7 . I am not worried about transaction failure & recovery scenarios We have already faced this 2 ...
Need help with below code, as it fails with truncation error Truncation error occurred. Command has been aborted. create table monCacheQuality ( ServerName sysname ...