Setting ascending inserts mode for a table

To turn on ascending insert mode for the sales table, use:

dbcc tune (ascinserts, 1, "sales")

To turn ascending insert mode off, use:

dbcc tune (ascinserts, 0, "sales")

These commands update the status2 bit of sysindexes.

If tables sometimes experience random inserts and have more ordered inserts during batch jobs, enable dbcc tune (ascinserts) only for the period during which the batch job runs.