I read questions in forums frequently that developers are very much worried about gaps in identity column. Suppose you have a table with identity column and addition and deletion are frequently performed. But the newly added identity column value is not always next number of lastly available value in the table. It is always next number of lastly generated value no matter if it exists in the table.
Do you have any real time scenario that gaps in identity are not acceptable?