Skip to content

Useful Commands

Benh LIEU SONG edited this page Mar 9, 2022 · 5 revisions

My own cheatsheet.

Increasing Master Device's Size

disk resize name = 'master', size = 13312

Increasing Master Database's Size

alter database master on master=78

Identity Gaps / Burning Factor

Global (Burning Factor)

To set it to 0.1% of all available identity numbers of each table, use following formula:

0.001*10^7 = 10000

and then run:

sp_configure 'identity burning set factor' 10000

On A Specific Table

To have ASE allocate identity numbers by batches of 20000:

CREATE TABLE xxx (
    ...
) WITH identity_gap = 20000

Activate Bulk Copy

sp_dboption '<database_name>', 'select into/bulkcopy', true
go

Changing the charset

to UTF-8

From the command line

$ charset -Usa -Psybase -SDB_TEST binary.srt utf8

Then in SQL

sp_configure 'default character set', 190
go
sp_configure 'default sortorder id', 50
go

Restart the server once. It applies the change and shutdown. Start it again.

back to ISO-8859-1

sp_configure 'default character set', 1
go
sp_configure 'default sortorder id', 50
go

Restart the server once. It applies the change and shutdown. Start it again.