Useful Commands

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