I'm having trouble determining what value to supply in order to set aside 1% of the possible identity values for a table. The Sybase manual has information which doesn't jibe, at least not how I'm reading it:
"When you set identity burning set factor, you express
the number in decimal form, and then multiply it by
10,000,000 to get the correct value to use with
sp_configure. For example, to release 15 percent (.15)
of the potential IDENTITY column values at one time,
you specify a value of .15 times 10,000,000
So, using the above description, to release 1% of the potential values I would set the burning set factor to 100,000
Then I read:
"When defining the IDENTITY column for the books
table, we used the default numeric value of (18, 0),
which provides a total of 999,999,999,999,999,999 ID
numbers. For the identity burning set factor
configuration parameter, we are using the default
setting of 5000 (.05 percent of 999,999,999,999,999,999),
which means that Adaptive Server allocates blocks
of 500,000,000,000,000 numbers."
which indicates that I'd want to use a value of 1,000.
Then, I found a post here where someone suggested that a value of 1 would be sufficient, which seems incredibly low compared to Sybase's documentation.