I have the following problem:
I'm working on a SQL db which already has some data inserted.
When a new row is inserted, the identity column doesn't get the "greatest"
but fills up the holes in the existing rows (for example if data has ID
1,2,4,5,6,7 new row gets 3 as ID, not 8).
Can someone tell me if there's any config to change this behaviour?